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.
I have a table where I am trying to create a coloumn with values from 1 to 7 based on monday to sunday and where the latest date is 1 and the day before that = 2 and so on
I have used the following calculation to create this but its not doing what im expecting. Im not sure why Sat is showing as -4 rather than 3
Any help would be appraciated
Solved! Go to Solution.
Hi @Mishelski
Try this code to add your column:
DOW sort flag =
VAR _daycheck =
WEEKDAY ( TODAY (), 2 )
RETURN
IF (
DIM_WEEKDAY_sort[WEEKDAY] >= _daycheck,
7 - ( DIM_WEEKDAY_sort[WEEKDAY] - _daycheck ),
_daycheck - DIM_WEEKDAY_sort[WEEKDAY]
)
Output:
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Hi @Mishelski
Try this code to add your column:
DOW sort flag =
VAR _daycheck =
WEEKDAY ( TODAY (), 2 )
RETURN
IF (
DIM_WEEKDAY_sort[WEEKDAY] >= _daycheck,
7 - ( DIM_WEEKDAY_sort[WEEKDAY] - _daycheck ),
_daycheck - DIM_WEEKDAY_sort[WEEKDAY]
)
Output:
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Thank you so much! This has worked perfectly! Really appreciate it!
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 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |