Help with a DAX Formula to Return Text in a Measure

Question

I have a table of data that looks like:&nbsp;IDSdatePdateDdateDstatus22A0B3A9&nbsp;&nbsp;&nbsp;&nbsp;6B63C3049/21/2018 9:391/8/2019 8:34&nbsp;&nbsp;4E1C2014&nbsp;&nbsp;&nbsp;&nbsp;29970ABD&nbsp;&nbsp;&nbsp;&nbsp;B59F619410/1/2018 23:0110/1/2018 23:101/30/2019 10:42Accept76DA99FA11/27/2018 14:3911/27/2018 14:481/8/2019 10:47AcceptE7F024E0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;I am trying to add a Results Column based on a slicer date value (in this case the date slice value is 12/18/18) that would make the data look like:&nbsp;IDSdatePdateDdateDstatusResult22A0B3A9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;6B63C3049/21/2018 9:391/8/2019 8:34&nbsp;&nbsp;Pending4E1C201410/1/2018 23:0110/1/2018 23:101/30/2019 10:42AcceptAccept29970ABD11/27/2018 14:3911/27/2018 14:481/8/2019 10:47AcceptPendingB59F619411/27/2018 14:3911/27/2018 14:481/8/2019 10:47&nbsp;Pending76DA99FA10/3/2018 14:4010/3/2018 14:4212/17/2018 11:31Conditional AcceptConditional AcceptE7F024E01/9/2019 18:491/9/2019 18:491/10/2019 11:37Accept&nbsp;9FA365088/22/2018 18:288/22/2018 18:33&nbsp;&nbsp;Pending&nbsp;If I was doing this in Excel, my formula would be&nbsp;=IF(AND([Ddate]&lt;&gt;"",[Ddate]&lt;=12/18/18),[Dstatus],IF(AND([Pdate]]&lt;&gt;"",[Pdate]&lt;=12/18/18),"Pending",IF(AND([Sdate]&lt;&gt;"",[Sdate]&lt;=12/18/18),"Pending","")))&nbsp;In DAX I am able build the logic in the proper DAX format, but the return value I am getting in the Measure is a not a text value. I actually get an error because it is says it is comparing Date types to Text types.&nbsp;While this isn't the full DAX forumla, it is the one I am testing for at least the first step in the comparison:&nbsp;St&nbsp;=IF&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;AND&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(&nbsp;MIN&nbsp;(&nbsp;TableA[Ddate]&nbsp;)&nbsp;&lt;&gt;&nbsp;""&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(&nbsp;MIN&nbsp;(&nbsp;TableA[Ddate]&nbsp;)&nbsp;&lt;= TableA[SlicerDateSelected]&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;MINA&nbsp;(&nbsp;SlateAppData[Dstatus]&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;"")&nbsp;[SlicerDateSelected] is just the Max value from a slicer on a date table I have created.&nbsp;What I am missing?

rrhutch · Accepted Answer

Figured my problem out. It wasn't an issue with the getting the result as a text value but my problem was the comparison was trying to compare date and text types. Instead I used the following to achieve what I needed. I was comparing a Date field to "" to determine if not blank. Everything worked fine once I used the BLANK() function instead in the comparison.&nbsp;&nbsp;St&nbsp;=SWITCH&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;TRUE&nbsp;(),&nbsp;&nbsp;&nbsp;&nbsp;AND&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MINA&nbsp;(&nbsp;TableA[Ddate] )&nbsp;&lt;&gt;&nbsp;BLANK&nbsp;(),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MINA&nbsp;(&nbsp;TableA[Ddate]&nbsp;)&nbsp;&lt;=&nbsp;[SlicerDateSelected]&nbsp;&nbsp;&nbsp;&nbsp;),&nbsp;MINA&nbsp;(&nbsp;TableA[Dstatus]&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;AND&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MINA&nbsp;(&nbsp;TableA[Pdate]&nbsp;)&nbsp;&lt;&gt;&nbsp;BLANK&nbsp;(),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MINA&nbsp;(&nbsp;TableA[Pdate]&nbsp;)&nbsp;&lt;=&nbsp;[SlicerDateSelected]&nbsp;&nbsp;&nbsp;&nbsp;),&nbsp;"Pending",&nbsp;&nbsp;&nbsp;&nbsp;AND&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MINA&nbsp;(&nbsp;TableA[Sdate]&nbsp;)&nbsp;&lt;&gt;&nbsp;BLANK&nbsp;(),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MINA&nbsp;(&nbsp;TableA[Sdate] )&nbsp;&lt;=&nbsp;[SlicerDateSelected]&nbsp;&nbsp;&nbsp;&nbsp;),&nbsp;"Pending",&nbsp;&nbsp;&nbsp;&nbsp;"")&nbsp;

Forum Discussion

Help with a DAX Formula to Return Text in a Measure

1 Reply

Related content

Measure returning incorrect value

Measure formula problem

If formula

formula

RANKX Formula Returning Duplicate Ranks

ID	Sdate	Pdate	Ddate	Dstatus
22A0B3A9
6B63C304	9/21/2018 9:39	1/8/2019 8:34
4E1C2014
29970ABD
B59F6194	10/1/2018 23:01	10/1/2018 23:10	1/30/2019 10:42	Accept
76DA99FA	11/27/2018 14:39	11/27/2018 14:48	1/8/2019 10:47	Accept
E7F024E0