Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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...
Solved! Go to 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.
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.
This works now, thanks!
@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 )
Hi! This has come up as an error..
The following syntax error occurred during parsing: Invalid token, Line 7, Offset 33, %.