Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a date table
and week ending date
Solved! Go to Solution.
@Anonymous , As the Only day does not have a month with it, you will not be able to set a sort column as weekend date.
But full dates like 3rd July 2021 (if formatted, mark week end date as sort column) , should sort correctly
How to Create Sort Column and Solve Related Errors: https://youtu.be/KK1zu4MBb-c
@Anonymous , As the Only day does not have a month with it, you will not be able to set a sort column as weekend date.
But full dates like 3rd July 2021 (if formatted, mark week end date as sort column) , should sort correctly
How to Create Sort Column and Solve Related Errors: https://youtu.be/KK1zu4MBb-c
That's the route I was going down, working on figuring out a column to sort the day on now
alternativly it works if I add month in above day from my regular date hierarchy