Need to Calculate week number as per Fiscal Year

[Dhrutivyasa-070]

Hello,

i need to calculate week number from 1 to 52 as per Fiscal Year in PowerBI

Fiscal Year Starts from April 

Output should like below:

Facing isuuse while appliying weeknum function 

after using dax Weeknum([date],2) it will give wrong output . 

Help me with the dax solution to calculate fiscal calander with week number 

Thanks in Advance!

[lbendlin]

Do not attempt to create Fiscal calendar tables in Power Query or in DAX.  You will be eternally unhappy.  Ask me how I know.

Use a static external reference table.

[shieldsco]

Bad advice