1st row value should be blank, 1st value should be at 2nd row place etc..

[Anonymous]

1st row value should be blank,

1st row value should be at 2nd row value place

2nd row value should be at 3rd row value place 

3rd row value should be at 4th row value place.

i have tried with earlier function 

like calculate(cal running total in FISCAL_QTR measure,

filter( tablename, fiscal_qtr = fiscal_qtr) but not coming output...earlier(fiscal_qtr) function can not be used for output of measure cal column. could you please help on this requirement.

[Anonymous]

OK. What's the reason for using ALLSELECTED in your code? Do you want a running total that would be dependent on what you show in your visual instead of on the full data set up to the current point in time?

[Anonymous]

How to do it? By the manipulation of the filter context. However, it would be certainly helpful if you showed your data's structure and formula(s) for a start.

[Anonymous]

i have tried with below dax 

test2 meas =

CALCULATE([Cal running total in FISCAL_QTR],

FILTER('FISCAL CALENDAR', 'FISCAL CALENDAR'[FISCAL_QTR]= 'FISCAL CALENDAR'[FISCAL_QTR]

))

// CALCULATE( [Cal running total in FISCAL_QTR],

// FILTER('FISCAL CALENDAR', 'FISCAL CALENDAR'[FISCAL_QTR] = FIRSTNONBLANKVALUE('FISCAL CALENDAR'[FISCAL_QTR],'FISCAL CALENDAR'[FISCAL_QTR])

// )

// )

// MAXX(

// FILTER('FISCAL CALENDAR', 'FISCAL CALENDAR'[FISCAL_QTR] = 'FISCAL CALENDAR'[FISCAL_QTR]

// &&

// 'FISCAL CALENDAR'[FISCAL_QTR]<'FISCAL CALENDAR'[FISCAL_QTR]

// ),[Cal running total in FISCAL_QTR])

data:

i have got below dax and trying samething but not working out