Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Date table with fiscal week numbers

Hi    Can i get some advice on how to write a date table with fiscal week number please . our company fiscal week starts on the first week of april and ends on the last week of march the following ...
Need Help
  • mwegener's avatar
    mwegener
    4 years ago

    Hi Anonymous ,

     

    Did I answer your question?
    Please mark my post as solution, this will also help others.
    Please give Kudos for support.

     

mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

Hi Anonymous ,

 

somehow I misunderstood the requirement, but have a look at the attached file.

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi mwegener 

 

 

Apologies for the late reply as I can only learn this over the weekend . 

 

I have watched a video on youtube and foloowed steps and done a calander and used your DAX code to get the FW numbers sorted . 

 

below is the link that i watched 

Date Dimension in Power BI with Financial or Fiscal Columns - YouTube

 

will have a play around and see if anything else needs to add . 

 

Many thanks for your help and much appreciated .

 

Cheers

  • mwegener's avatar
    mwegener
    Icon for Most Valuable Professional rankMost Valuable Professional
    4 years ago

    Hi Anonymous ,

     

    Did I answer your question?
    Please mark my post as solution, this will also help others.
    Please give Kudos for support.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      HI I HAVE THE SAME QUESTION, but i cant view the solution? please thanks

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        the formula i need is for power query not power bi please