Can't Get DatesinPeriod to Work properly

[Sean-OReilly]

Hi

I'm using the below DAX 

Costs last 2 months = calculate ( [Total Costs to Date], DATESINPERIOD(MK_Job_LedgerEntries[Posting_Date], max(MK_Job_LedgerEntries[Posting_Date]), -2, MONTH ))

My issue is that when I apply the measure against a Table that also has the Job Number it is using the Max Date of the posting against that Job and working back 2 months from there. I want it to calculate the Max date based on Today's date, not the most recent posting date against that job.

For example, if the last cost posted against a Job was 31/12/2022 - then it is giving me costs for the period 01/11/2022 to 31/12/2022. I actually want it to give me Zero as there has been no costs posted since 31/12/2022.

The Max Date needs to refer to today as an absolute value. i have tried various things like creating a Column for Today's date in the table but that is not working for me either.

I really need help on this one.

Thanks in advance. 

[v-tangjie-msft]

Hi @Sean-OReilly ,

Please try this measure.

Costs last 2 months = 
CALCULATE(
    [Total Costs to Date],
    DATESINPERIOD(
        MK_Job_LedgerEntries[Posting_Date],
        TODAY(),
        -2,
        MONTH
    )
)

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[Sean-OReilly]

Hi @v-tangjie-msft 

Thanks for coming back to me.

Unfortunatley it did not work. It just comes back Blank

Here is what i tried 

Costs last 2 months v2 = calculate ( [Total Costs to Date], DATESINPERIOD(MK_Job_LedgerEntries[Posting_Date], today(), -2, MONTH ))

[Sean-OReilly]

Should Add A Column instead of Using a Measure ?