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,
Below is the table I'm working on, to which I'm to add another column that will display the Friday's date of the week in all its rows.
Date Day
12/5/2019 Sun
13/5/2019 Mon
14/5/2019 Tue
15/5/2019 Thurs
16/5/2019 Fri
17/5/2019 sat
I expect as the following output:
Date Day Expected Output
12/5/2019 Sun 17/5/2019
13/5/2019 Mon 17/5/2019
14/5/2019 Tue 17/5/2019
15/5/2019 Wed 17/5/2019
16/5/2019 Thur 17/5/2019
17/5/2019 Fri 17/5/2019
18/5/2019 Sat 24/5/2019
19/5/2019 Sun 24/5/2019
20/5/2019 Mon 24/5/2019
21/5/2019 Tues 24/5/2019
22/5/2019 Wed 24/5/2019
23/5/2019 Thurs 24/5/2019
24/5/2019 Fri 24/5/2019
23/5/2019 Sat 24/5/2019
Using dax how can I achieve this one.
Solved! Go to Solution.
MyFriday = CALCULATE(MAX('Table'[Date]), FILTER('Table', 'Table'[Weeknum] = EARLIER('Table'[Weeknum]) && 'Table'[Day] = "Fri"))
Is this the result you are expecting?
Thanks for your reply. I have formed the weeknum column, could you please let me know how you created MyFriday column or attach Pbix file, it will be helpful for me
Regards,
Yuvaraj
MyFriday = CALCULATE(MAX('Table'[Date]), FILTER('Table', 'Table'[Weeknum] = EARLIER('Table'[Weeknum]) && 'Table'[Day] = "Fri"))
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 |
---|---|
109 | |
97 | |
80 | |
67 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |