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]))
    )
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous 

Try like

new column = dateadd([REPORTDATE],-1,month)

Or
new column =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