Forum Discussion

LucasAlcarde's avatar
LucasAlcarde
Icon for Advocate I rankAdvocate I
3 years ago

Show Data in Matrix until last date

I need to show the data Show Data in Matrix until last date in the last year . I need in this format, because is important at the analysis moment to compare name with only the last date

 

1 Reply

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    3 years ago

    Hi,

    I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

    Please check the below picture and the attached pbix file.

    I hope the below can provide some ideas on how to create a solution for your dataset.

     

     

     

     

    Qty sum: = 
SUM( Data[Qty] )

     

    Only show when the last month is not blank: =
VAR _thelastmonth =
    CALCULATE (
        MAX ( Data[Month-Year] ),
        INDEX (
            -1,
            ALL ( 'Month'[Month-Year], 'Month'[Month end date] ),
            ORDERBY ( 'Month'[Month end date], ASC )
        ),
        REMOVEFILTERS ( Customer[Customer] )
    )
VAR _thelastmonthqty =
    CALCULATE (
        [Qty sum:],
        FILTER ( ALL ( 'Month' ), 'Month'[Month-Year] = _thelastmonth )
    )
VAR _condition =
    NOT ISBLANK ( _thelastmonthqty )
RETURN
    IF (
        HASONEVALUE ( Customer[Customer] ),
        [Qty sum:] * DIVIDE ( _condition, _condition )
    )