cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Pcarrasg Helper I
Helper I

Problem whit LTM

Hello,
I want to use this structure but dynamically;

HH_for = CALCULATE ([High + white + low F];
'TRAINING' [PERIOD] = 201903 ||
'TRAINING' [PERIOD] = 201902 ||
'TRAINING' [PERIOD] = 201901 ||
'TRAINING' [PERIOD] = 201812 ||
'TRAINING' [PERIOD] = 201811 ||
'TRAINING' [PERIOD] = 201810 ||
'TRAINING' [PERIOD] = 201809 ||
'TRAINING' [PERIOD] = 201808 ||
'TRAINING' [PERIOD] = 201807 ||
'TRAINING' [PERIOD] = 201806 ||
'TRAINING' [PERIOD] = 201805 ||
'TRAINING' [PERIOD] = 201804)

Before suggesting other options, try the following:
HH_for = CALCULATE ([High + white + low F];
DATESINPERIOD ('TRAINING' (end_date); MAX ('TRAINING' (end_date)); - 12; MONTH)

3 REPLIES 3
Super User IV
Super User IV

Re: Problem whit LTM

What is the exact problem, not very clear from the description?





Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @
My Recent Blog -Week is not so Weak Proud to be a Super User! Connect on Linkedin


Community Support
Community Support

Re: Problem whit LTM

@Pcarrasg ,

 

It seems like you need to achieve rolling total of previous 12 months? Could you share some sample data and clarify more details?

 

Regards,

Jimmy Tao

Pcarrasg Helper I
Helper I

Re: Problem whit LTM

Screenshot_5.pnginitial relationshipScreenshot_6.png1. This is the result you should get. 2. HH_for as we see the result is approachingScreenshot_7.pngUsing Datesinperiod -12 MonthScreenshot_8.pngthis option I get the correct results but in a static way. option dynamically?Screenshot_9.pngRelationship option 2Screenshot_10.pngResultsScreenshot_11.png2º EJample

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors