Column If condition not working for measure value.

[ashish_18]

HI Team, Can you please help me with below issue.

I am calculating measure NovForecast as below 

NovForecast = CALCULATE('data'[TotalForecast1],FILTER('data','data'[Index]=1))

TotalForecast1 is total of current cost column as calculate function only take measure value.

I am now creating column  as BRMain  but NovForecast value is not getting displayed in column . I am creating column BRMain as below 

BRMain = IF('data'[Index] = 2, 'data'[NovForecast], 'data'[brCCC])

Sample data is as below.

Index	Month	FI Name	Sum of Current Cost	Runway by CF MAIN	Sum of BRMain	NovForecast
1	Nov	CCC	$218,228	2819358	253132	218228
1	Nov	BBB	$3,536	441286	39401	3536
1	Nov	AAA	$210,935	2085510	78058	210935
2	Dec	CCC	$159,400	2659958
2	Dec	BBB	$3,097	438189
2	Dec	AAA	$109,713	1975797
3	Jan	CCC	$190,645	2469313	190645
3	Jan	BBB	$15,464	422725	15464
3	Jan	AAA	$167,727	1808070	167727
4	Feb	CCC	$183,136	2286177	183136
4	Feb	BBB	$13,541	409184	13541
4	Feb	AAA	$146,721	1661349	146721
5	Mar	CCC	$193,967	2092210	193967
5	Mar	BBB	$19,176	390008	19176
5	Mar	AAA	$169,900	1491449	169900
6	Apr	CCC	$229,776	1862434	229776
6	Apr	BBB	$24,984	365024	24984
6	Apr	AAA	$187,931	1303518	187931
7	May	CCC	$283,923	1578511	283923
7	May	BBB	$12,844	352180	12844
7	May	AAA	$161,276	1142242	161276
8	Jun	CCC	$257,771	1320740	257771
8	Jun	BBB	$39,147	313033	39147
8	Jun	AAA	$195,140	947102	195140
9	Jul	CCC	$280,560	1040180	253132
9	Jul	BBB	$57,266	255767	39401
9	Jul	AAA	$215,752	731350	78058
10	Aug	CCC	$336,528	703652	253132
10	Aug	BBB	$73,255	182512	39401
10	Aug	AAA	$243,131	488219	78058
11	Sep	CCC	$337,392	366260	253132
11	Sep	BBB	$88,453	94059	39401
11	Sep	AAA	$231,547	256672	78058
12	Oct	CCC	$366,260	0	253132
12	Oct	BBB	$94,059	0	39401
12	Oct	AAA	$256,672	0	78058

[HotChilli]

I think you are telling us that [TotalForecast1] is a measure but it is not good practice to use a measure in a column. It is not advisable.

So re-write the BRMain column.

--

Also, are you writing a calculated column that gets the Nov values for December rather than writing a generic LastMonthValue column?

[ashish_18]

Hi @HotChilli  Thansk for your response. Can you plz advise how to write BRMain column for that IF condition

Will LastMonthValue work for me coz Dec is not my last month here..