Dynamic date filter in matrix to create 3 columns yesterday,today,tomorrow

[Anonymous]

Hello,

So I have this matrix which displays a value with as row countries and columns dates atm its filtered on days so it displays 1-31

I want a measure or some way of dynamically filtering so instead of 1-31 it displays as columns yesterdays date todays date and tomorrow. I figured I need to make use of today() function but cant quite figure out how to retrieve the multiple dates. I invision it as something like return today -1, return today , return today +1. Any help with this would be appreciated.

[Anonymous · Accepted solution]

Got it by filtering the actual value on dates already so you don't need to create a seperate measure or slicer for date filtering.

measure = CALCULATE(COUNT(Shipment_info_3days[SHIPMENT]);ISBLANK(3days[PAYWEIGHT])=FALSE; 3days[PAYWEIGHT]>= 3500; 3days[DATE] = TODAY()-1 || 3days[DATE] = TODAY() || 3days[DATE] = TODAY()+1)