Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
fazza1991
Helper II
Helper II

Fiscal week calendar

Hi,

I have a  calendar table already created in Power Query.

I have created a fiscal year which starts 01/07 (1st of July).

Now i want to create weeks starting from 01/07

 

Please note this needs to be Power Query / M Script solution not DAX

 

Thanks

2 REPLIES 2
ppm1
Solution Sage
Solution Sage

Please see if this article/video helps.

445 Calendar with 53-Week Years – Hoosier BI

 

Pat

Microsoft Employee
Ahmedx
Super User
Super User

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.