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  
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 )
    )