Forum Discussion
MOM Calc do not work with global date filter
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
MaggieCommunity 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.
Community SupportHi 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
