Forum Discussion

KW123's avatar
KW123
Icon for Helper V rankHelper V
4 years ago
Solved

Last Date previous month

I have this DAX for a measure YTD Funded = CALCULATE([What does YTD total need to be], LASTDATE ( PREVIOUSMONTH (Dates[Date] ))) I need to calculate the value of the above measure.  In my rep...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi @KW123 ,

    Do you want to get the values from the beginning of the year to the end of the previous month? If yes, you can create a measure as below:

     

    YTD Funded =
    CALCULATE (
        [What does YTD total need to be],
        FILTER (
            ALLSELECTED ( 'Table' ),
            'Table'[Date] >= DATE ( YEAR ( TODAY () ), 1, 1 )
                && 'Table'[Date] <= EOMONTH ( TODAY (), -1 )
                && 'Table'[Date] <= SELECTEDVALUE ( 'Table'[Date] )
        )
    )

     

    In addition, you can refer the following links to get it.

    Calculate Year-to-date Values

    YTD DAX

    How to get a last day of previous month in Power BI

     

    If the above one is not working for you, please provide some sample data(exclude sensitive data) with Text format and your expected result with special examples and screenshots. It is better if you can provide me a simplified pbix file. Thank you.