Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi all,
i have table query with 4 columns : DATE, SALES, SALES 22 and SALES 23.
My date column has date from 01-jan-2022 to today, the SALES column have the value and the SALES 22 and 23 columns are conditional columns with values only for the specified year. The problem is that my sales values are cumulative, so for february I have jan+feb, for march i have jan+ feb + march....
I'm tryng to find the MoM for each year so i can compare Month sales from Jan23 to sales of Jan22 and so on, and i want to have an Histogram like this :
I have 2 measures to calculate MoM for each year but having only one date column when i try to compare them, my jan 2023 sales values are negative.
I also tried to work with 2 different table, one for 2022 and one for 2023, and link them to a calendar table, and in this case the measures work but i cant compare MoM in my histogram because of the dates, as i have an X-axis starting at jan-2022 and ending in dec-2023.
Can someone help me ?
Thank u in advance
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.