Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |