Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a financial Dashboard which I am filtering on reporting month through a slicer. I have some Month on Month figures which are working fine when the reporting date filter comes directly from the same data source. I am adding other operational statistics from other data sources to the Dashboard and making a relationship between all the sources' 'Reporting Date' with a new 'Date Table'. Now I can filter all data sources on the Dashboards through the common Date Table. However, the MOM figures now turn blank....
I would guess that the my previous month formula is no longer able to look at previous month:
Revenue LM = CALCULATE([Revenue];PREVIOUSMONTH(CBS[ReportPeriod]))
Anyone knows a solutions to having MOM figures and visualizations from other data sources on the same Dashboard with a common date fitler for the dashboard visualizations?
Any feedback appreciated 🙂
Paal
Solved! Go to Solution.
Hi @Qtzalcoatl
How do you create relationships between the the table( where [Revenue] is) and date table ("CBS" this is a date table?) ?
Please create a relationship based on "date" columns for two tables.
Which visual do you add the "year","month" columns and measure [Revenue LM] in?
Could you share a screenshot to show which fields to add in the visual?
You could read more about " PREVIOUSMONTH" function and how to use it.
https://community.powerbi.com/t5/Desktop/PREVIOUSMONTH/td-p/13307
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Qtzalcoatl
How do you create relationships between the the table( where [Revenue] is) and date table ("CBS" this is a date table?) ?
Please create a relationship based on "date" columns for two tables.
Which visual do you add the "year","month" columns and measure [Revenue LM] in?
Could you share a screenshot to show which fields to add in the visual?
You could read more about " PREVIOUSMONTH" function and how to use it.
https://community.powerbi.com/t5/Desktop/PREVIOUSMONTH/td-p/13307
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks Maggie!
I changed reference in PREVIOUSMONTH to the common Date table instead of the Date column in my revenue table. That solved it!
Thanks again 🙂
Paal
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |