If statement in DAX-how to implement for measures %, and the output as a quarter end date.

[andyly85]

Hi team, I am trying to implement a new measure which outputs the quarter end date if a measure is >25%, else blank  So far I have coded in DAX:  But having no success so far...

>25% = IF('Rank'[Largest Client %] > 25%, "December 22")

[v-binbinyu-msft · Accepted solution]

Hi @andyly85 ,

You just need do a simple modification, change 25% to 0.25, please try below dax formula:

>25% = IF([Column1]>0.25,"December22")

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[andyly85]

This works now, thanks!

[amitchandak]

@andyly85 , Assume you need qtr for today of selected date

Qtr =
var _today = if(isfiltered('Date'),MAX( 'Date'[Date]) , today())
var _max = eomonth(_today, if( mod(Month(_today),3) =0,0,3-mod(Month(_today),3)))

return

IF('Rank'[Largest Client %] > 25%, _max )

[andyly85]

Hi!  This has come up as an error..

The following syntax error occurred during parsing: Invalid token, Line 7, Offset 33, %.