Python to Dax help

[Anonymous]

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 Fiscal Year starts the week containing May 1st (Sun -Sat) and operates on 445 calendaring. If anyone could guide me on how to convert it that would be a huge help, thanks.

Thanks a ton

[Anonymous]

Hi @vapid128 

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

[vapid128]

Sorry, my mistake.

IsFiscalWeek = "5/1" in CALCULATETABLE(VALUES(Dates2[MMD]),ALLEXCEPT(Dates2,Dates2[weeknum])

[Anonymous]

@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]

IsFiscalWeek = "5/1" in 

CALCULATETABLE(

    VALUES(Dates2[MMD]),

    ALLEXCEPT(Dates2,Dates2[weeknum])

)

And you date colnum should not skip in date 

[Anonymous]

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

[vapid128]

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]))

[vapid128]

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]))