Forum Discussion

Pawan's avatar
Pawan
Frequent Visitor
3 years ago
Solved

Previous Year DAX Calculation

Hi Team   Please can you help me on below issue. I have created a table like below in power bi. By default current month selection is applied and calculated CY and PY measures like below   CY= C...
DAX
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi Pawan 

    please try

    PY =
    CALCULATE (
    [CY],
    FILTER (
    SAMEPERIODLASTYEAR ( 'Date'[Date] ),
    FORMAT ( [Date], "MMDD" ) <= FORMAT ( TODAY (), "MMDD" )
    )
    )

amitchandak's avatar
amitchandak
Super User
3 years ago

Pawan ,

 

PY = CALCULATE([CY], SAMEPERIODLASTYEAR('Date'[Date]), format([Date],"MMDD") <= format(today() ,"MMDD")  )

Pawan's avatar
Pawan
Frequent Visitor
3 years ago

amitchandak thank you for your reply. The above solution works only for complete year(2022) selection. But is breaking when we select month or quarter. The measure should be dynamic based on Date selection.