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

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.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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