Forum Discussion

CracktheCode85's avatar
CracktheCode85
Icon for Helper II rankHelper II
2 years ago
Solved

Nested IF Statement in a Filtered Dates Calculation

Hello,   I'm using this formula to get the total sales for 2 business days ago. So if today is Business day 16, this formula is showcasing the Total sales for business Day 14.  However I want to ...
Need Help
CracktheCode85's avatar
CracktheCode85
Icon for Helper II rankHelper II
2 years ago

Hey AmiraBedh 
I've been trying to get this formula to work and it seems like BI is just ignoring the '-2' section of the formula??? 

 

Two Day Lookback = CALCULATE(SUM('Table'[Payments]),

FILTER('Dates'

      ,'Dates'[Bank Day Numbers] >= 1

      && 'Dates'[Bank Day Numbers] <=CALCULATE(MAX('Dates'[Bank Day Numbers]), FILTER(Dates, Dates[Date] = TODAY()-2)

)))

Am I not connecting the right tables to the 'Today()-2))' portion???