Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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 was a way to include in my DAX formula which show if a previous month score or current month score is not showing anything, then there is no % change? I highlighted the examples.
Solved! Go to Solution.
@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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 20 | |
| 11 | |
| 10 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 34 | |
| 31 | |
| 19 | |
| 12 | |
| 11 |