Forum Discussion

Paddhof1984's avatar
Paddhof1984
Helper 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
Paddhof1984's avatar
Paddhof1984
Helper III
9 years ago

Daniil

 

What I can provide you with the overview of the tables and their relationsships. Or which type of sample data do you exactly need?

 

I have the tables:

 

RE2015 (turnover for 2015)

RE2016 (turnover for 2016)

RE2017act (turnover for 2017 for the current year).

 

 

For 2015 and 2016 (always the past years) the same turnover periods should be shown as far as the turnover period is actually shown for the current year.

 

 

Daniil's avatar
Daniil
Kudo Kingpin
9 years ago

Thanks Paddhof1984. I would try something like this:

2015 YTD =
CALCULATE (
    SUM ( RE2015[QTY] ),
    INTERSECT ( VALUES ( RE2015[Month] ), VALUES ( RE2017act[Month] ) )
)

Does this help?

  • Paddhof1984's avatar
    Paddhof1984
    Helper III
    9 years ago

    Daniil

     

    Thanks for your quick reply. No, somehow the measure shows empty on the chart:

     

    • Daniil's avatar
      Daniil
      Kudo 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
        Helper III
        9 years ago

        Daniil Thanks for your support. One more thing:

         

        Is there any possibility to add a measure which cumulates the monthly turnover for the ytd measure?

        So I can compare ytd turnover for 2016 to the current to 2017?