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...
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
IsFiscalWeek = "5/1" in
CALCULATETABLE(
VALUES(Dates2[MMD]),
ALLEXCEPT(Dates2,Dates2[weeknum])
)
And you date colnum should not skip in date
I've made the changes and it just returns false. I've tried every different formatting option but it still returns False each time
We need all date in date colnum.
If we cant have all date, we can create a date table with all date.
datetable = CALENDAR(MIN(table[date]),MAX(table[date]))