Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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"))