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
rlupe's avatar
rlupe
Frequent Visitor
3 years ago

I got the same results as the screenshot, it is probably due to when I select the Order Creation Year drilldown. I think by drilling down it holds back the previous year data because they are two different date columns, not sure. I have a date table, then on a different table there is create date and billing date. I could be getting them crossed up.

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.