Forum Discussion
Anonymous
5 years agoNot applicable
Best Approach for Global Calendar
Hi, I have created dashboard and their is request to change the format of calender. I have used excel file with dates from 2020-01-01 to 2022-12-31 in single colum. And merged with other columns an...
- 5 years ago
Anonymous , Not very clear. Why don't you create a calendar in power bi?
1.Creating Financial Calendar - From Any Month
https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calendar-1-5-Power/ba-p/1187441
2.Any Weekday Week - Start From Any day of Week
https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Power-BI-Turning/ba-p/1187482or refer
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
- 5 years ago
mahoneypat
Microsoft Employee
5 years ago- Anonymous5 years agoNot applicable
Thank You for the response, It worked nicely