Forum Discussion
DAX Formula Question
Hello all! I am reaching out because I created a table which displays scores from a current month and previous month, and the % change from them. (See Below). One question I was wondering is if there...
Anonymous , try a measure like
if(isblank([current month]) || isblank([previous month]) , blank(), divide([current month], [previous month]) )
Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA
Anonymous , try a measure like
if(isblank([current month]) || isblank([previous month]) , blank(), divide([current month], [previous month]) )
Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA