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 - how does one change the below to be able to use the Switch function? TIA
The goal is that for any day of the week, the date reverts to the most recent Friday.
Solved! Go to Solution.
@josevaras
You can do it this way as well:
Data Thru = TODAY() - WEEKDAY(TODAY(),16)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@josevaras
You can do it this way as well:
Data Thru = TODAY() - WEEKDAY(TODAY(),16)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thanks for responding. Can you explain to me why type 16?
@josevaras
It sets the week start day as Saturday, check the following table so the weekday gives number three by which the date is pushed back by three days.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Try the following:
New Column = SWITCH(TRUE, WEEKDAY(TODAY() ) = 1 , TODAY() -2
WEEKDAY(TODAY() ) = 2 , TODAY() -3
WEEKDAY(TODAY() ) = 3 , TODAY() -4 ....., TODAY())
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |