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.
Hi.
I have a DCalendar table with a field to identify the day of the week in the month.
I need her to start counting the week from Thursday.
Example S1 from December 2020 (days 1, 2 and 3) - S2 (from 4 to 10) and so on!
Can anyone help me do the DAX for this?
Solved! Go to Solution.
Hi @Anonymous ,
I believe from your screenshot you want you week to start on Friday (04/12/2020).
Two different options:
- Power Query Editor --> Date.WeekOfMonth
- Calculated column in DAX:
Regards,
Hi @Anonymous ,
I believe from your screenshot you want you week to start on Friday (04/12/2020).
Two different options:
- Power Query Editor --> Date.WeekOfMonth
- Calculated column in DAX:
Regards,
Dear Payeras_BI
Thank you for your feedback and time in doing the example.
It was just what I needed.
I'm new to powerquery and DAX, I did a lot of research before posting on the forum and was not getting it.
I will study the commands that you put.
hey,
you could add a new column with some nested ifs,
new column = if(weekday(date) = 5, "S2",if(weekday(date) = 6,"S2",... and so on
number 5 of the week its thursday
if this helped or resolve your problem give some kudos and mark as solutions for others to find.
Proud to be a Super User!
hello StefanoGrimaldi
Thanks for the feedback, but I didn't understand how to apply it.
Can you set up an example?
if you put S2 for every number 5 every Thursday will be S2 and that's not what I need.
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 |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |