cancel
Showing results for
Did you mean:
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

## Re: Problem whit LTM

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

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

## Re: Problem whit LTM

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

Helper I

## Re: Problem whit LTM

initial relationship1. This is the result you should get. 2. HH_for as we see the result is approachingUsing Datesinperiod -12 Monththis option I get the correct results but in a static way. option dynamically?Relationship option 2Results2º EJample

Announcements

#### Announcing the New Spanish Forum

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

#### MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

#### ‘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