Forum Discussion
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...
You need a colnum of dates.
let us name it to [date].
add 3 colnums:
MMD = MONTH([Date])&"/"&DAY([Date])
weeknum = WEEKNUM([Date])
IsFiscalWeek = "5/1" in CALCULATETABLE(VALUES(Dates2[MMD]),ALLEXCEPT(Dates2,Dates2[weekIndex]))