Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi people, Need your help to solve my query. Straight to my question-
I want to compare (monday -monday) or (tuesday - tuesday) sales for the respective week.
Example: June 1st week Monday - July 1st week Monday(Dates can vary). How do I do this? your help is very much appreciated.
I want this to be dynamic. irrespective of the months i compare. Always the respective week(Day - Mon,tue,wed etc..) data should map with another.
Solved! Go to Solution.
Hi @Anonymous
Thanks for reaching out to us.
One idea, you can use edate() function to get the date 1 or 2 months ago, then filter date by same weekday number, for example (sample file attached below)
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
Thanks for reaching out to us.
One idea, you can use edate() function to get the date 1 or 2 months ago, then filter date by same weekday number, for example (sample file attached below)
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.