Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Using TODAY in Measures

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?

Need Help

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

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

      • v-huizhn-msft's avatar
        v-huizhn-msft
        Microsoft Employee
        9 years ago

        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