Forum Discussion

Sofie's avatar
Sofie
Regular Visitor
8 years ago

last month amount

Hi,

 

I wrote a measure like this:

InboundDeliveriesPlannedToday = CALCULATE(COUNT(LIKP[Delivery]);LIKP[Delivery Type] = "EL"; LIKP[Delivery Date] = TODAY(); 'Calculated LIPS'[all delivered] = "NO")

 

I want to compare this nr with the average of last month. So basically for everyday of the previous month I want to sum the amount that satisfies the conditions and then divide this amount with the nr of days (30 or 31) in this month.

I don't know how to start with writing such a measure

 

Thanks in advance!

Need Help

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    8 years ago

    Hi Sofie

    You could consider the DAX function DATEADD to get date of last month, then use these date as a filter in CALCULATE function to sum the amount.

    If you have problem ding so, please share some example date with me so that i can help you.

     

    Best Regards

    Maggie