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.
As variant to modify this measure or use another one on the top of it
Date Settled:=IF( ISBLANK([Settled Date]), "Not Settled", [Settled Date] )Hi Sergei,
thank you for the response.
I seem to have done something wrong.I add a measure and pasted the formula (I did slightly modify to add Table 2 in front of [Settled Date] as you can see in the pic below. I guess that is correct.
I get an error saying that [Settled Date] cannot be determined.
What do you suggest? thank you.
Based on your screenshot my understanding was that Settled Date is measure, not calculated column. If so, please create another measure exactly as in my sample.
If that is /calculated/ column as in your latest post - that doesn't work, it shall be something else depends on which and where result you'd like to have. We need to know what measure shall return for non-blanks.
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
