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 report, the column What does YTD total need to be, as a value. However if I select the YTD funded column into the report, it just shows $0.... 

Thanks, 
  • 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.

6 Replies

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

      Hi daXtreme 

      From the screen shot, the YTD funded returns a value of $0.  For February, it should have a value, let's just say $1000 for example.  It is based off the last day of the month value of the previous month (January) of the What does YTD total need to be measure. 

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

    I have not been able to find a DAX for this anywhere online.  Any help would be appreciated! 

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

      So I have created a column which shows me the last day of each month.  Now I'm trying to figure out how to use that to get the value from the last day of the previous month with an IF clause that gives a blank for January 2022. (since the previous month will be in 2021 and we do not have the data for it) 

      • Anonymous's avatar
        Anonymous
        Not applicable
        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.