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 
       
      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        I've made the changes and it just returns false. I've tried every different formatting option but it still returns False each time