Forum Discussion
Dax Measure - If Null add text
I see, so Settled Date is the column in Table2, not measure. I have no idea which aggregation you'd like to show for this field in PivotTable, let assume min of Settled Date:
min Settled:=MINX( Table1, Table1[Settled Date] )In addition, when above is blank we would like to show some text. That could be
Date Settled:=IF( ISBLANK([min Settled]), "Not Settled", [min Settled] )Of course, both could be combined in one measure, depends on goals.
Sergei, I think it is only a measure and not calculated. I do not do any calculations on the Settled Date...only a measure. But maybe I am missing something.
here is a screen shot of the measures I have:
I have 4 measures. I dont think any are considered calculated.
Let me know what is the next step. thank you
I see, so Settled Date is the column in Table2, not measure. I have no idea which aggregation you'd like to show for this field in PivotTable, let assume min of Settled Date:
min Settled:=MINX( Table1, Table1[Settled Date] )In addition, when above is blank we would like to show some text. That could be
Date Settled:=IF( ISBLANK([min Settled]), "Not Settled", [min Settled] )Of course, both could be combined in one measure, depends on goals.
- Amazing. That worked. I used MIN as suggested and the IsBlank. thank you very much for the help. Works perfectly.
Tony2021 , you are welcome, glad to help