Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Everyone,
Wondering if anyone knows how to create a WEEK ENDING NUMBER by date directly into the creating of a Date Table.
This is what I have, but the Week Ending Number Column definitely isn't correct, "Week Ending By" is at the bottom.:
It just repeats the MAX date over and over again.
Any help would be greatly appreciated.
Thank you much...
HI,
I am not sure how your semantic model looks like, but try something like below whether it suits your requirement.
"Week End Num",
MAXX ( RELATEDTABLE ( 'Orders' ), 'Orders'[ShipDateKey] ))
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
User | Count |
---|---|
53 | |
28 | |
19 | |
18 | |
14 |
User | Count |
---|---|
92 | |
86 | |
39 | |
24 | |
22 |