cancel
Showing results for 
Search instead for 
Did you mean: 

retrieve next month data

ypinchuk
Explorer
0 Kudos
133

Hello,

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

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

ypinchuk_1-1707416575136.png

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

Thank you 

 

 

View Entire Topic
N1kh1l
Active Contributor
0 Kudos

@ypinchuk 

I have used below and it seems to work

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

Output:

N1kh1l_0-1707420864353.png

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

N1kh1l_1-1707420909345.png

 

Br.

Nikhil

 

 

 

ypinchuk
Explorer
0 Kudos
Thanks! The key was to use the default Date hierarchy