Feb 05 2022 04:22 PM
Hello, I have a power pivot as shown below with a dax measure.
I want to display text when the date (Settled Date) is blank.
How can I do this?
thank you
Feb 05 2022 05:52 PM
Feb 06 2022 12:55 AM
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] )
Feb 06 2022 08:25 AM
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.
Feb 06 2022 09:18 AM
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.
Feb 06 2022 09:38 AM
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
Feb 06 2022 10:01 AM
SolutionI 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.
Feb 06 2022 11:43 AM
Feb 06 2022 10:01 AM
SolutionI 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.