Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have the following table showing percentage change versus current and previous value:
Is there a way to group this monthly showing the database size for the last day of current month versus last day of the previous month and so on?
Thanks,
Frank
Solved! Go to Solution.
@anelliaf
Not sure what output do you want, maybe provide a picture to show the expected result.
However, to get change of the last day of current month versus last day of the previous month. Hope this measure helps you.
Measure =
Var CurrentMonthLastday = CALCULATE(SUM('Table'[database size]),ENDOFMONTH('Table'[Date]))
Var PreviousMonthLastday = CALCULATE(SUM('Table'[database size]),ENDOFMONTH(PREVIOUSMONTH('Table'[Date])))
Return (CurrentMonthLastday-PreviousMonthLastday)/PreviousMonthLastday
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@anelliaf
Not sure what output do you want, maybe provide a picture to show the expected result.
However, to get change of the last day of current month versus last day of the previous month. Hope this measure helps you.
Measure =
Var CurrentMonthLastday = CALCULATE(SUM('Table'[database size]),ENDOFMONTH('Table'[Date]))
Var PreviousMonthLastday = CALCULATE(SUM('Table'[database size]),ENDOFMONTH(PREVIOUSMONTH('Table'[Date])))
Return (CurrentMonthLastday-PreviousMonthLastday)/PreviousMonthLastday
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The table i posted shows a few rows with dates and database size. The database size for the last day of the month is what I need, not a SUM.
Thanks in advance for your help!
This sum in measure doesn't mean add up the values, it does not do calculations (min or max would get the same).
You may try this measure, it should return the specific value of the last day of the month only.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
144 | |
73 | |
63 | |
52 | |
51 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |