Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
What I feel should be easy has me stumped this morning I am tying to create a simple YTD calculation of "Item Total New" for the current year but with an end date being the last day of the previous week. I have the fact table joined to a date table that has a lastdayofweek column. I pulled in the values using a slicer as shown in the top chart for validation purposes and the second table is using my measure shown at the top of screen. I am able to get the YTD easily but its giving me total through today. Any help would be greatly appreciated.
Solved! Go to Solution.
Hi @lkhall as you want control dates / weeks what will be visible / calculated you need "appropriate flag" up to / after certain day / week. Check link below, part as named. Hope this help / kudos appreciated.
Proud to be a Super User!
Hi @lkhall as you want control dates / weeks what will be visible / calculated you need "appropriate flag" up to / after certain day / week. Check link below, part as named. Hope this help / kudos appreciated.
Proud to be a Super User!
User | Count |
---|---|
50 | |
23 | |
18 | |
18 | |
14 |
User | Count |
---|---|
91 | |
84 | |
43 | |
26 | |
21 |