Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

wrong week returned?

We are in week 40, in either system 1 and 2. But pbix returns 41, why??

 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    15 means, week begins on friday? (that is not what I want... week begins on monday).

     

    As I have it my dimDate:

     

    Date, Week

    2020-12-31 53
    2021-01-01 53
    2021-01-02 53
    2021-01-03 53
    2021-01-04 1

    ****

    2021-12-31 52
    2022-01-01 52
    2022-01-02 52
    2022-01-03 1

     

    (which return_type shall I use to match the above)

    • VahidDM's avatar
      VahidDM
      Super User
      4 years ago

      Hi Anonymous 

      Use 21 as a return_type in your DAX.

       

      Output:

       

      If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

      Appreciate your Kudos!!