Forum Discussion
Solved
DAX Formula causing Continuous Values For Future and Past Months
Hi There! I am once again faced with a strange issue.... I have a calculation for a percentage where the Numerator and Denominator are both formulated to stop at the current month. I.E. We will...
Hi CracktheCode85 ,
Please find the below DAX expression. It would be good to sahre sample data to work on DAX expression when you are posting.
%PM =
IF(
NOT( ISBLANK( [Denom] ) ),
1
- DIVIDE( [Num], [Denom] ),
BLANK()
)Please let me know if you have further questions.
If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks!
Best Regards,
Maruthi
Hi,
Does this measure work?
Measure = if(isblank([Num]),blank(),divide(([Num]-[Denom]),[Denom]))
Hope this helps.