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.
Hello,
I have a monthly forecast that is entered on the first/second day of the month, and I want to count the number of fiscal months in that month, pro rata the total amount, and then graph that pro rata'd amount over each fiscal week in that month so we can compare with weekly sales.
Please see link to PBIX file Monthly Allocation Test.pbix and the desired result screenshot of the table below for the first few months
Thanks!
Hi Yilong Zhou, thanks so much for your reply. The picture of the table and graph i showed was the desired solution, using the dataset in the PBIX file/model I sent a link to in the original post - the dataset looks like the below. Thanks! Monthly Allocation Test.pbix
Thanks!
Hi @watje255_ju ,
I create a table as you mentioned.
Then I get an Index column and create a new calculated column.
Column =
VAR _Current = 'Table'[Fiscal Week2]
RETURN
CALCULATE (
MAX ( 'Table'[Monthly Allocation] ),
FILTER ( ALL ( 'Table' ), 'Table'[Fiscal Week2] = _Current )
)
When I Put it into the Stacked column chart, you will get what you want.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
38 | |
26 | |
20 | |
15 | |
8 |
User | Count |
---|---|
69 | |
47 | |
46 | |
20 | |
15 |