Forum Discussion

bhuprakashs's avatar
bhuprakashs
Icon for Helper I rankHelper I
1 year ago
Solved

Calculate Last Month till Today date

Hi team, I need help in writing a measure for last month till today date.  Condition: If I select December month from slicer then November month value should be shown till 12th only not for entire m...
Need Help
  • bhuprakashs's avatar
    bhuprakashs
    1 year ago

     bchager  yes your code is working perfectly which is handling previous year also. May be my DAX is looks working because my slicer has YearMonth column which is single select only. 
    But I am going to use your code only to avoid any issue in future. 
    Thank you again for helping me. 

bhuprakashs's avatar
bhuprakashs
Icon for Helper I rankHelper I
1 year ago

Hi bchager , I found one solution on the web which is working for me. Here is the syntex. Kindly check.

Previous Month's value to today's day  =
CALCULATE (
    sum ( value ),
    DATEADD (
        FILTER ( DATESMTD ( Dates[Date] ), Dates[Date] <= TODAY () ),
        -1,
        MONTH
    )
)
bhuprakashs's avatar
bhuprakashs
Icon for Helper I rankHelper I
1 year ago

 bchager  yes your code is working perfectly which is handling previous year also. May be my DAX is looks working because my slicer has YearMonth column which is single select only. 
But I am going to use your code only to avoid any issue in future. 
Thank you again for helping me. 

  • bchager's avatar
    bchager
    Icon for Resolver III rankResolver III
    1 year ago

    bhuprakashs Glad I could help. That was a fun one to figure out and I hope for the benefit of others that you'd mark my solution as the solution.