Forum Discussion
DAX Formula causing Continuous Values For Future and Past Months
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 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
Hey Maruthisp!
That did the trick! The Current Month of MAY still shows 100% but I can work with that.
I'm not sure I fully understand how or why it worked... would you mind providing a breakdown of how that formula works with the Blanks?
