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,
I want to show the Revenue value (in a card) for last month in the selected range of months (selected in month slicer i.e. If the month range in slicer is from Jan 17 to Dec 17 then card should dislay revenue in Dec 17; means that what ever is the last month in the range. It can Apr 16 to Mar 17 then revenue value of Mar 17 should be shown. How can this be done? currently it shows the sum of all the months that are selected.
Thanks
Solved! Go to Solution.
@asifnazir,
Please create the following measures in your table.
lastday = MAX(Table[DateKey])
firstday = DATE(YEAR([lastday]),MONTH([lastday]),1)
revenue of last month = CALCULATE(SUM(Table[Revenue]),DATESBETWEEN(Table[DateKey],[firstday],[lastday]))
Regards,
Lydia
@asifnazir,
Please create the following measures in your table.
lastday = MAX(Table[DateKey])
firstday = DATE(YEAR([lastday]),MONTH([lastday]),1)
revenue of last month = CALCULATE(SUM(Table[Revenue]),DATESBETWEEN(Table[DateKey],[firstday],[lastday]))
Regards,
Lydia
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.