Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Last value from each month

  • 1.  Last value from each month

    Posted 30 days ago
    Hi guys,
    Good evening!

    I'm in need of help developing a measure that brings me the last value for each month, including the last current month value.
    I'm using "ENDOFMONTH" and it's working, but it only brings the last value of the past months. It does not bring the current month value.
    Can someone help me?

    Ex.:
    VAR TEST =
    CALCULATE ( SUM ( 'Unidades'[valor] ), ENDOFMONTH ( Unidades[data] ) ,
    FILTER('Unidades','Unidades'[Letra] = "A"))

    Marcio.


  • 2.  RE: Last value from each month

    Posted 29 days ago
    Try LASTDATE

    LASTDATE – DAX Guide


    ------------------------------
    Rick Gosden
    Systems Analyst
    [
    ------------------------------