Rolling 12 month not returning anything

[Anonymous]

Hi,

I have the following  measure, however it is not returning anything.. unique ref has values in so not sure what is going on there?

No of Referrals = 
    CALCULATE(
    count(Referrals[UniqueRef]),
    DATESINPERIOD( 'Calendar'[Date], MAX( 'Calendar'[Date] ), -12,  MONTH )
)

Any help appreciated

[James-Harpin · Accepted solution]

So currently this will be doing the max date in 2040 minus 12 months, try changing the MAX date function to TODAY()

[James-Harpin]

Hi @Anonymous 

For your MAX of Calendar Date is this value today, or a date in the future?

[Anonymous]

Hi ames,

The Calendar goes to 2040 but i am wanting rolling twelves months from today.

Thanks

[Anonymous]

Thanks James thats returning a result now which is great however if i put it next to the month name its returning the same number? against every date in the date table even though there is a two way connection between both tables?