Forum Discussion

CJANE's avatar
CJANE
Icon for Helper I rankHelper I
8 years ago
Solved

LAST DATE FROM FILTERED DATA

I am having trouble finding a solution to displaying units sold based on last date in a date column.  For example:  I have a data set that includes Trust Symbol, Date Sold, Manufacture, and Units Sol...
Need Help
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    CJANE

     

    Hi, Try with this measure:

     

     

    UnitsSold-LastDate =
CALCULATE (
    SUM ( Table1[Units Sold] ),
    FILTER (
        Table1,
        Table1[Date Sold]
            =  CALCULATE ( LASTDATE ( Table1[Date Sold] ), ALL ( Table1 ) ) 
    )
)

    Regards

     

    Victor

    Lima - Peru

     

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
8 years ago

CJANE

 

Hi, Try with this measure:

 

 

UnitsSold-LastDate =
CALCULATE (
    SUM ( Table1[Units Sold] ),
    FILTER (
        Table1,
        Table1[Date Sold]
            =  CALCULATE ( LASTDATE ( Table1[Date Sold] ), ALL ( Table1 ) ) 
    )
)

Regards

 

Victor

Lima - Peru

 

  • CJANE's avatar
    CJANE
    Icon for Helper I rankHelper I
    8 years ago

    Thank you!!  Saved me a lot of time and grief.