Forum Discussion

NehaSha's avatar
NehaSha
Icon for Helper II rankHelper II
7 years ago
Solved

How to return values based on if dates are within Slicer date range

Hi All, I am new to Power BI& and need help to resolve the below mentioned scenario Report Need to show Date Range Slicer& Card 1: value for SUM(Net Rent) based on Date Range Card 2:value for GP b...
Need Help
  • ElenaN's avatar
    ElenaN
    7 years ago

    Hello,

     

    You can try this:

     

    GPIEndDate = 
VAR LastSelectedDate = LASTDATE(ALLSELECTED(Table3[Date]))
RETURN
CALCULATE(SUM(Table3[GPI]), FILTER(Table3, Table3[Date] = LastSelectedDate))

    GPILYEndDate = 
    VAR LastSelectedDate = LASTDATE(ALLSELECTED(Table3[Date])) 
    RETURN CALCULATE(SUM(Table3[GPILY]), FILTER(Table3, Table3[Date] = LastSelectedDate))

    Regards,

    ElenaN

ElenaN's avatar
ElenaN
Icon for Resolver V rankResolver V
7 years ago

Hello,

 

You can try this:

 

GPIEndDate = 
VAR LastSelectedDate = LASTDATE(ALLSELECTED(Table3[Date]))
RETURN
CALCULATE(SUM(Table3[GPI]), FILTER(Table3, Table3[Date] = LastSelectedDate))

GPILYEndDate = 
VAR LastSelectedDate = LASTDATE(ALLSELECTED(Table3[Date])) 
RETURN CALCULATE(SUM(Table3[GPILY]), FILTER(Table3, Table3[Date] = LastSelectedDate))

Regards,

ElenaN

NehaSha's avatar
NehaSha
Icon for Helper II rankHelper II
7 years ago

Working fine and got the expected results! Thank you very much!