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 guys,
I would like to have my date starting from september to august (to do a fiscal year)
Does somebody know how i can do it ?
Thanks
Have a good day
Solved! Go to Solution.
Hi @NnIc0 ,
You can create a calendar table by Calendar function. And create a custom fiscal year number sort column:
FYMonthNum =
VAR FYStartMonth = 12
//Update the fiscal year starting month above *Use number between 1 to 12
RETURN
IF (
MONTH ( Dates[Date] ) >= FYStartMonth,
MONTH ( Dates[Date] )
– ( FYStartMonth – 1 ),
12
+ (
MONTH ( Dates[Date] )
– ( FYStartMonth – 1 )
)
)
Sort the month column in calendar table by the custom column and create relationship between your fact table and calendar table.
For more details, please refer to https://www.powerobjects.com/blog/2018/12/19/sorting-data-fiscal-year-power-bi/
Best Regards,
Dedmon Dai
Hi @NnIc0 ,
You can create a calendar table by Calendar function. And create a custom fiscal year number sort column:
FYMonthNum =
VAR FYStartMonth = 12
//Update the fiscal year starting month above *Use number between 1 to 12
RETURN
IF (
MONTH ( Dates[Date] ) >= FYStartMonth,
MONTH ( Dates[Date] )
– ( FYStartMonth – 1 ),
12
+ (
MONTH ( Dates[Date] )
– ( FYStartMonth – 1 )
)
)
Sort the month column in calendar table by the custom column and create relationship between your fact table and calendar table.
For more details, please refer to https://www.powerobjects.com/blog/2018/12/19/sorting-data-fiscal-year-power-bi/
Best Regards,
Dedmon Dai
@NnIc0 , Please find
https://www.dropbox.com/s/fwys71ccx5mquxx/Sep_2_Aug_Cal.pbix?dl=0
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |