Forum Discussion
Solved
Measure Sales IF current date YN
Hi there, how to create a DAX Measure = Customer receivables / Customer Sales with Condition: from 1-29/30 take sales from previous month if 30/31 (month last day) take sale from full current mont...
mrslyfox,
For Octorber, you want to get current month sales if today is 31-Oct but not 30-Oct, right? If so, create Customer sales measure using the DAX below.
Customer sales = IF(TODAY()=EOMONTH(TODAY(),0),CALCULATE(SUM(Invoice[NetAmt]),PARALLELPERIOD(Date[Date],0,MONTH)),CALCULATE(SUM(Invoice[NetAmt]),PREVIOUSMONTH(Date[Date])))
Regards,
Lydia
mrslyfox,
For Octorber, you want to get current month sales if today is 31-Oct but not 30-Oct, right? If so, create Customer sales measure using the DAX below.
Customer sales = IF(TODAY()=EOMONTH(TODAY(),0),CALCULATE(SUM(Invoice[NetAmt]),PARALLELPERIOD(Date[Date],0,MONTH)),CALCULATE(SUM(Invoice[NetAmt]),PREVIOUSMONTH(Date[Date])))
Regards,
Lydia