Forum Discussion

MelbourneBadger's avatar
MelbourneBadger
Helper I
5 years ago
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. 
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    Just put -1 instead of 0 on the initial EOMONTH

    Best regards

    Pat

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

I'm guessing this relates to your previous post.  If so, this should combine the two

 

Calendar =
VAR eomonthtoday =
    EOMONTH (
        TODAY (),
        0
    )
VAR startdate =
    DATE ( 2019, 1, 1 )
VAR series =
    GENERATESERIES (
        0,
        DATEDIFF (
            startdate,
            eomonthtoday,
            MONTH
        ),
        1
    )
RETURN
    ADDCOLUMNS (
        series,
        "Date",
            EOMONTH (
                startdate,
                [Value]
            )
    )

 

Regards,

Pat

MelbourneBadger's avatar
MelbourneBadger
Helper I
5 years ago

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. 

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    5 years ago

    Just put -1 instead of 0 on the initial EOMONTH

    Best regards

    Pat