The curse of the previousmonth not working

[MyWeeLola]

Good afternoon

I used this code to create a date table

Date =

CALENDAR(

    MIN(tblMarch2024[Date Observation Entered]),

    MAX(tblMarch2024[Date Observation Entered])

    )

I set the table as a date table and the table now contains contiguous data from the 1/1/24 until 7/4/24 ( dd/mm/yy)

I then watched you tube, as you do, and added this abridged code to allow me to filter the underlying table

Date Periods =

var _sd = min('Date'[Date])

var _ed = max('Date'[Date])

RETURN

UNION(

    ADDCOLUMNS(

        DATESMTD('Date'[Date]),

        "Type","MTD",

        "Order",4

    ),

    ADDCOLUMNS(

        DATESQTD('Date'[Date]),

        "Type","QTD",

        "Order",6

    ),

    ADDCOLUMNS(

        CALENDAR(_ed-7,_ed),

        "Type","Last 7 Days",

        "Order",1

    ),

    ADDCOLUMNS(

        CALENDAR(_ed-14,_ed),

        "Type","Last 14 Days",

        "Order",2

    ),

    ADDCOLUMNS(

        PREVIOUSQUARTER('Date'[Date]),

        "Type","Last Qtr",

        "Order",7

    ),

    ADDCOLUMNS(

        PREVIOUSYEAR('Date'[Date]),

        "Type","Last Year",

        "Order",9

    ),

    ADDCOLUMNS(

        datesytd('Date'[Date]),

        "Type","This Year",

        "Order",8

    ),

    ADDCOLUMNS(

        PREVIOUSMONTH('Date'[Date]),

        "Type","Last Month",

        "Order",3

    )

)

I set the date columns to short date, and expected to sit back with it all working.

I added the date periods to a slicer and set the relationships.

Everything works, except for the ones which say"previous" first, The dates qtd, mtd and calendar work fine. however the others do not appear in the slicer and are not in the underlying table.

Can someone explain where I messed up, please?

Lola

[Greg_Deckler · Accepted solution]

@MyWeeLola You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000

Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...

[MyWeeLola]

@Greg_Deckler 

Thank you, that resolved the issue and I can now resume with reckless abandon, thank you.

[MyWeeLola]

@Greg_Deckler 

Good morning, a few weeks ago you solved an issue I was having with time issue I was having.

I now have another quick question, where after reading you code, there may not have been a solution in there.

What I need is a a rolling date range which gives me the month, prior to the previous month.

For example. In May, the previous month is April. I need to display figures for March in one area and April in another as a comparison. As June approaches, I will then need to display April and May.

How would I achieve this? My thoughts are the use of a previous to previous month measure. How could I achieve that?

I look forward to hearing from you.

Lola

[MyWeeLola]

@Greg_Deckler  Much appreciated, I shall read it and respond shortly.