Forum Discussion

ThisIsHalloween's avatar
ThisIsHalloween
Helper I
2 years ago
Solved

Table Based Off Date Measure Not Populating

I have a measure that calculates the last date in a table:   Last Date in Receipts CY = MAX(Receipts[BI Date])   I have a second measure that takes that same date and subtracts a year: ...
Need Help
  • ThisIsHalloween's avatar
    ThisIsHalloween
    2 years ago

    I tried this as well hoping that it would work but not luck so I think it's that I am using edate but I don't know what to use instead:

     

     

    PY = 
FILTER (
    Receipts,
    AND (
        Receipts[BI Date] >= DATE ( 2022, 7, 1 ),
        Receipts[BI Date] <= edate([Last Date in Receipts CY],-12)
    )
)

     

ThisIsHalloween's avatar
ThisIsHalloween
Helper I
2 years ago

I tried this as well hoping that it would work but not luck so I think it's that I am using edate but I don't know what to use instead:

 

 

PY = 
FILTER (
    Receipts,
    AND (
        Receipts[BI Date] >= DATE ( 2022, 7, 1 ),
        Receipts[BI Date] <= edate([Last Date in Receipts CY],-12)
    )
)