retrieve next month data

[ypinchuk]

Hello,

How can I create a Calculated Measure to get data from the next month?

I want Next (Jan) = Measure(Feb). 

I tried to use LOOKUP([Measure], [d/Date] = Next ("Month", 1)) but it gave me no result

Thank you 

[N1kh1l · Accepted solution]

@ypinchuk 

I have used below and it seems to work

LOOKUP([QUANTITY] ,[d/Date]= Next("Month", 1))

Output:

Make sure the hierarchy used in the table widget for Date dimension is the default hierarchy

Br.

Nikhil

[ypinchuk · Accepted solution]

Thanks! The key was to use the default Date hierarchy