Forum Discussion

rlupe's avatar
rlupe
Frequent Visitor
3 years ago

How to get same month last year data to populate when using a second date drilldown?

Hi,   I am attempting to build a PBI that looks at ordering data based on the date an order was created, but I want to see the month that it was billed in. My 'This Year' data is correct, but my 'L...
Need Help
Syk's avatar
Syk
Icon for Resident Rockstar rankResident Rockstar
3 years ago

Try to remove filters on your order creation year and see if that helps.. Something like 

Bulletin (LY) =
CALCULATE (
    [Bulletin (TY)],
    DATEADD (
        'Date Table'[date],
        -1,
        YEAR
    ),
    REMOVEFILTERS ( 'Some Table'[Creation Year] )
)



rlupe's avatar
rlupe
Frequent Visitor
3 years ago

That is very close! It is technically applying it to the correct month/year, but I am trying to get January 2021 on the same line as January 2022.

 

I am trying to incorporate sametimeperiod last year to bring it down to the same year. Is there a way to re-add the year after the calculation is already done? I tried doing DATEADD in another measure but it did not hold the values from prev calculation.