Measure Sales IF current date YN

[mrslyfox]

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 

[Anonymous · Accepted solution]

@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