I'm trying to create a table/matrix visual where given data, I add a column that is MoM comparison, but only for the last month.
Given a Dummy table, I'd like my visual to present like that in April:
Dummy table in April:
The month before, upon no data of April, the visual would look like below:
I am able to create MoM measure for all months, and even only for the latest month, using methods similar to presented here.
The problem is that when I use that as a measure, in the best case, I can only get an empty MoM column for previous months. The goal is to have MoM column only at the end, and only for the most recent period.
Solved! Go to Solution.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.