Forum Discussion
MelbourneBadger
Helper I
Helper IDynamic 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
MelbourneBadgerHelper I
Helper IThank 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.
mahoneypat
Microsoft Employee
Microsoft EmployeeJust put -1 instead of 0 on the initial EOMONTH
Best regards
Pat