Forum Discussion
Solved
Dynamic GENERATESERIES
Hi All, How can I create a dynamic GENERATESERIES that will add by 1 at the start of each month? Thank you for the support before-hand.
Just put -1 instead of 0 on the initial EOMONTH
Best regards
Pat
Thank you mahoneypat .
Yes this relates to my question in the other thread.
This works, but how can I adjust the DAX such that the last end of the month date is from the previous month, ie. based on today's date, the last EOM date of the series is 31/10/2020?
Again thank you very much for your kind support.
Just put -1 instead of 0 on the initial EOMONTH
Best regards
Pat