Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi guys,
I have created a cumulative calculated measure
Measure = CALCULATE(SUM(meAccountTransaction[Deposits]),(FILTER(ALL(meCalendar[DateValue]),meCalendar[DateValue]<=MAX(meCalendar[DateValue]))))
Am using a Calender table which has dates until end of 2018, hence the line chart is showing all days of the month
Is there any Date measure I can use to filter out the excess days (the future days/months/years) that I can create/apply?
Thanks,
Majd
Solved! Go to Solution.
Thanks @BhaveshPatel it worked as a treat. I found PostingDateID in the meAccountTransaction, and I did have Datekey in my calander!
one more question, if I want to create a Datekey for other tables I have, what formula should I use for a custom column to tranform a Date to DateKey in the same formart you stated in your earlier reply?
Thanks,
Majd
Use this formula in Calculated Column to create a DateKey Column.
DateKey=meCalender[CalendarYear]*10000 + meCalender[Month Number]*100+DAY(meCalender[DateValue])
User | Count |
---|---|
96 | |
85 | |
77 | |
66 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |