Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX HELP

I want a column for showing day of last month. But dax is showing data in a different way. CURRDAYPREVMONTH = DATE(YEAR(ACX_Dates[Date]), MONTH(ACX_Dates[Date])-1, DAY(ACX_Dates[Date]))   ACT...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago
    Hacky, but you could always do this:

    Column 2 =
    IF(DAY([REPORTDATE]) > DAY(EOMONTH([REPORTDATE],-1)),
    DATE(YEAR([REPORTDATE]),MONTH([REPORTDATE])-1,DAY(EOMONTH([REPORTDATE],-1))),
    DATE(YEAR([REPORTDATE]),MONTH([REPORTDATE])-1,DAY([REPORTDATE]))
    )
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Already used this same formula, result is different.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago
Hacky, but you could always do this:

Column 2 =
IF(DAY([REPORTDATE]) > DAY(EOMONTH([REPORTDATE],-1)),
DATE(YEAR([REPORTDATE]),MONTH([REPORTDATE])-1,DAY(EOMONTH([REPORTDATE],-1))),
DATE(YEAR([REPORTDATE]),MONTH([REPORTDATE])-1,DAY([REPORTDATE]))
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks a lot Greg. It worked for me.

    I need one more help

     

    I want to calculate current Fiscal Year End Date (April - March)

    Suppose for Today, Fiscal year end date should be 31-03-2021