Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Python to Dax help

Hello all,   I am currently trying to convert this below code into something that I can paste into DAX and create a new column that reads a date column and returns the fiscal week. To clarify, my F...
Help
how to
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi vapid128 

 

Where does "Dates2[weekIndex] come from? Is that just the original date column? 

  • vapid128's avatar
    vapid128
    Solution Specialist
    4 years ago
    Sorry, my mistake.
     
    IsFiscalWeek = "5/1" in CALCULATETABLE(VALUES(Dates2[MMD]),ALLEXCEPT(Dates2,Dates2[weeknum])
    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      vapid128 

       

      When I try to make the IsFiscalWeek column I receive the following error message. I've tried changing Date and MMD value formats but none are working. 

       

      Thanks

       

      • vapid128's avatar
        vapid128
        Solution Specialist
        4 years ago
        IsFiscalWeek = "5/1" in 
        CALCULATETABLE(
            VALUES(Dates2[MMD]),
            ALLEXCEPT(Dates2,Dates2[weeknum])
        )
         
         
        And you date colnum should not skip in date