Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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]))
You need a colnum of dates.
let us name it to [date].
add 3 colnums:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
76 | |
50 | |
46 | |
16 | |
12 |