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 All,
I am working with a non-standard date table in Power BI. Usually our fiscal year is July to June, but sometimes week 1 of the fiscal year actually starts in June.
When doing my calculations at the minute, all sales for week 1 are comeing into June sales, which is not accurate when it comes to June sales. I want week 1 (when in June, month 6) to fall into sales in July.
I have tried to work with my m code in the advanced editor, on the date table to manipulate, if wk1 and month = June(month 6), then override to =July(or month 7), else June. But this is giving me 2x July months in my month list.
Does anyone have any suggestions? Mcode manipulation was the 1st thing I thought of, but happy if there is a DAX caculation too.
Thanks,
Noelle.
@Nurry90 , for the calendar of your choice
1.Creating Financial Calendar - From Any Month
https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calend...
For FY Week - https://www.youtube.com/watch?v=euIC0dgGTNM
or Week That Resets Yearly
https://community.powerbi.com/t5/Community-Blog/Week-That-Resets-Yearly-Decoding-Date-and-Calendar-3...
it's maybe better to provide your sample data and the calculation logic.
Hi @wdx223_Daniel ,
It won't let me load my sample pbix file. Sorry I am new here, what should I do? I have attached a screenshot of what my data is showing.
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 |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |