Forum Discussion

Chrism123's avatar
Chrism123
Frequent Visitor
8 years ago

Last Date YTD

Hi,

 

hope somebody can help me.

 

I  would need a formula that calculates the last date per month for all YTD dates.

 

If I select 21.03.2018 it should show me the following values:

 

31.01.2018

28.02.2018

21.03.2018

 

 

 

Need Help

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    8 years ago

    Well, I suppose that if you had a date table, you could use MAX with a filter per month, but you really can't return a table of values from a measure typically.