Forum Discussion
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 month
for 'previous month' = CALCULATE(SUM(Invoice[NetAmt]),PREVIOUSMONTH(Date[Date]))
for 'current month' = CALCULATE(SUM(Invoice[NetAmt]),PARALLELPERIOD(Date[Date],0,MONTH))
so if today 27-Oct -> measure return = Customer receivables / Customer Sales previous month
or if today 30-Oct -> measure return = Customer receivables / Customer Sales current month
also issue with february
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
1 Reply
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