Using TODAY in Measures

[Anonymous]

I have a column formula that works great when there is a month filter.  I need a similar formula that does not require the month filter.  What my formula is doing is adding up Friday, Saturday and Sunday shipping dollars if today is Monday.  Here is my formula. 

Shipped Yesterday = if(WEEKDAY(today())=2,if('Daily Sales Report Query'[Day]=today()-1,'Daily Sales Report Query'[Net $Sales],0)+ if('Daily Sales Report Query'[Day]=today()-2,'Daily Sales Report Query'[Net $Sales],0)+ if('Daily Sales Report Query'[Day]=today()-3,'Daily Sales Report Query'[Net $Sales],0),if('Daily Sales Report Query'[Day]=today()-1,'Daily Sales Report Query'[Net $Sales],0))

How can this be rewritten to work with no month filter and is bases solely on today's actual date?

[MattAllington]

There is almost certainly a better way, but there is not enough information to help you. Have a read of my advice here and post back a samp,e workbook https://exceleratorbi.com.au/get-help-power-bi/

[Anonymous]

Alas my data is all confidential and it would be too much work to re-create a sample version.

[v-huizhn-msft]

Hi @Anonymous,


Based on your scenario, I can not get your requirements. And what's the month filter? The month field is not used in your formula? Please share more details, so that we can post the solution which is close to what you want.

Best Regards,
Angelia