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

Any chance you could supply some sample data so that it is easier for us to help you?

  • Paddhof1984's avatar
    Paddhof1984
    Icon for Helper III rankHelper 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
      Icon for Kudo Kingpin rankKudo 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
        Icon for Helper III rankHelper III
        9 years ago

        Daniil

         

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