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

For this, I would append all three RE tables into one and have a proper date type column and a calendar table -- then the easiest way to create such a measure would be using Quick Measures.

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

Daniil

 

Hello again.

 

Is there any possibility to limit the ytd for the same time period as last year only to previous months? Like July is the current month, but I only need the turnover for past months which are completed. IS there any possibility to add this to your measure above?

  • Daniil's avatar
    Daniil
    Icon for Kudo Kingpin rankKudo Kingpin
    9 years ago

    Not in an easy way, as far as I know. It would be better to add a date column -- then you can definitely do what you want.