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 guys, hope you can help me out here.
I am having some trouble coming up with a solution for a problem I'm facing:
We are supposed to display sales on a monthly basis.
However, there are two sets of Sales data, "Monthly" and "Daily".
The "Monthly" data contains the most accurate the data and will only typically ready (Consolidated) by the "15th" of the following month.
E.g> Today is 2nd of March, which means that the "Monthly" data of Feburary will not be ready until the "15th" of March.
The "Daily" data, is collected daily but should not be used for reporting as much as possible.
This is a screenshot of what I currently have:
The chart above is currently only showing Monthly data.
How can I create a measure to show a combination of Monthly and Daily data?
If today is 2nd March > Selecting the Slicer (Year 2020, Qtr 1) it should show the following > Sum of January "Monthly" sales data + Sum of 1st Feburary to 2nd March "Daily" sales data.
If today is 16th March > Selecting the Slicer (Year 2020, Qtr 1) it should show the following > Sum of January to Feburary "Monthly" sales data + 1st to 16th March "Daily" sales data.
Selecting previous Years within the slicer should also only show "Monthly" data.
The data is structured in a way that both "Daily" and "Monthly" data are in the same dataset/column differentiated by a seperate column (Type: "Daily", "Monthly"). A calendar table ("CalendarDate") with the transaction date has also been created.
Hope you guys can help me out with this, appreciate it! Thank you in advance!
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
50 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |