Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
Anonymous
Not applicable

Sum of MoM change

Hi,

 

i have a time intelligence measure:

fgaertne103119_0-1700734385055.png

whereas

fgaertne103119_1-1700734420860.png

Using the the MoM measure in a table visualization i can see the ABS MoM change per Resource Name & Task Name, but what i actually need is the sum of the ABS MoM changes per month e.g. a table that would show me below result for 2023 March for a particular Resource Name of 3.06 (as indicated below) :

fgaertne103119_3-1700734728082.png

It seems pretty straightforward but i fail to get a viable solution.

Please help!

 

Thanks

Felix

3 REPLIES 3
Anonymous
Not applicable

I think in principle this measure should work (at least it does for a similar case that i've tested):

fgaertne103119_1-1700753852354.png

but apparently due to the time intelligence expression for SUMX it doesn't 😞

 

Maybe just a little tweak is needed here?!

Anonymous
Not applicable

Tried the MoM non-TimeIntelligence from here: https://amitchandak.medium.com/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e but can't make it work either (issue to even get the value for rank-1..)

Anonymous
Not applicable

I think I have narrowed down the issue. It is SUMX not working when a task disappeared from one month to another. The table/summation (when removing the task column) is working fine except for the cases where MoM change is -100% or 1 in absolute terms:

 

fgaertne103119_0-1701004823327.png

 
with
TEST_MD_%_per_task_MoM_change_ALLTASK = SUMX(SUMMARIZE(TimeTracking, TimeTracking[Task Name]), [TEST_MD_%_per_task_MoM_change])
 
I have to SUMMARIZE by [Task Name] otherwise i get 0 when removing the task name column but this i assume is at the same time leading to the issue that when the task only exists in a previous month it is not taken into consideration in the subsequent month.
 
Any sort of idea or help are still appreciated

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.