Forum Discussion

Paddhof1984's avatar
Paddhof1984
Icon for Helper III rankHelper III
9 years ago

YTD

Hello,   I am curious whether there is anyone who can help me out with following situation:   I do have 3 tables, each of them contains the total turnover from a specific year:   2015 (whole ye...
Need Help
Daniil's avatar
Daniil
Icon for Kudo Kingpin rankKudo Kingpin
9 years ago

Paddhof1984
Made a typo, sorry. This should work:

2015 YTD =
CALCULATE (
    SUM ( RE2015[QTY] ),
    INTERSECT ( VALUES ( RE2015[Month] ), VALUES ( RE2017act[Month] ) )
)
Paddhof1984's avatar
Paddhof1984
Icon for Helper III rankHelper III
9 years ago

Daniil

 

I have another point regarding the intersection of values: the Intersection of old years compared to the new year works perfect.

 

Now I do have following measure:

 

TO2017 cumul. = TOTALYTD(SUM(RE2017act[2017])|'Calendar'[Date])

 

How can I intersect this one, so that only months are shown, where turnover is generated? In this case, it still shows values for the rest of the year and for months, which still are to come but where no turnover has been created until yet.