topic Column If condition not working for measure value. in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Column-If-condition-not-working-for-measure-value/m-p/4067498#M161475 <P>HI Team, Can you please help me with below issue.</P><P>I am calculating measure&nbsp;NovForecast as below&nbsp;</P><P>&nbsp;</P><P>NovForecast = CALCULATE('data'[TotalForecast1],FILTER('data','data'[Index]=1))</P><P>TotalForecast1 is total of current cost column as calculate function only take measure value.</P><P>&nbsp;</P><P>I am now creating column&nbsp; as&nbsp;BRMain&nbsp; but&nbsp;NovForecast value is not getting displayed in column . I am creating column BRMain as below&nbsp;</P><P>BRMain = IF('data'[Index] = 2, 'data'[NovForecast], 'data'[brCCC])<BR /><BR />Sample data is as below.</P><TABLE><TBODY><TR><TD>Index</TD><TD>Month</TD><TD>FI Name</TD><TD>Sum of Current Cost</TD><TD>Runway by CF MAIN</TD><TD>Sum of BRMain</TD><TD>NovForecast</TD></TR><TR><TD>1</TD><TD>Nov</TD><TD>CCC</TD><TD>$218,228</TD><TD>2819358</TD><TD>253132</TD><TD>218228</TD></TR><TR><TD>1</TD><TD>Nov</TD><TD>BBB</TD><TD>$3,536</TD><TD>441286</TD><TD>39401</TD><TD>3536</TD></TR><TR><TD>1</TD><TD>Nov</TD><TD>AAA</TD><TD>$210,935</TD><TD>2085510</TD><TD>78058</TD><TD>210935</TD></TR><TR><TD>2</TD><TD>Dec</TD><TD>CCC</TD><TD>$159,400</TD><TD>2659958</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>2</TD><TD>Dec</TD><TD>BBB</TD><TD>$3,097</TD><TD>438189</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>2</TD><TD>Dec</TD><TD>AAA</TD><TD>$109,713</TD><TD>1975797</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>3</TD><TD>Jan</TD><TD>CCC</TD><TD>$190,645</TD><TD>2469313</TD><TD>190645</TD><TD>&nbsp;</TD></TR><TR><TD>3</TD><TD>Jan</TD><TD>BBB</TD><TD>$15,464</TD><TD>422725</TD><TD>15464</TD><TD>&nbsp;</TD></TR><TR><TD>3</TD><TD>Jan</TD><TD>AAA</TD><TD>$167,727</TD><TD>1808070</TD><TD>167727</TD><TD>&nbsp;</TD></TR><TR><TD>4</TD><TD>Feb</TD><TD>CCC</TD><TD>$183,136</TD><TD>2286177</TD><TD>183136</TD><TD>&nbsp;</TD></TR><TR><TD>4</TD><TD>Feb</TD><TD>BBB</TD><TD>$13,541</TD><TD>409184</TD><TD>13541</TD><TD>&nbsp;</TD></TR><TR><TD>4</TD><TD>Feb</TD><TD>AAA</TD><TD>$146,721</TD><TD>1661349</TD><TD>146721</TD><TD>&nbsp;</TD></TR><TR><TD>5</TD><TD>Mar</TD><TD>CCC</TD><TD>$193,967</TD><TD>2092210</TD><TD>193967</TD><TD>&nbsp;</TD></TR><TR><TD>5</TD><TD>Mar</TD><TD>BBB</TD><TD>$19,176</TD><TD>390008</TD><TD>19176</TD><TD>&nbsp;</TD></TR><TR><TD>5</TD><TD>Mar</TD><TD>AAA</TD><TD>$169,900</TD><TD>1491449</TD><TD>169900</TD><TD>&nbsp;</TD></TR><TR><TD>6</TD><TD>Apr</TD><TD>CCC</TD><TD>$229,776</TD><TD>1862434</TD><TD>229776</TD><TD>&nbsp;</TD></TR><TR><TD>6</TD><TD>Apr</TD><TD>BBB</TD><TD>$24,984</TD><TD>365024</TD><TD>24984</TD><TD>&nbsp;</TD></TR><TR><TD>6</TD><TD>Apr</TD><TD>AAA</TD><TD>$187,931</TD><TD>1303518</TD><TD>187931</TD><TD>&nbsp;</TD></TR><TR><TD>7</TD><TD>May</TD><TD>CCC</TD><TD>$283,923</TD><TD>1578511</TD><TD>283923</TD><TD>&nbsp;</TD></TR><TR><TD>7</TD><TD>May</TD><TD>BBB</TD><TD>$12,844</TD><TD>352180</TD><TD>12844</TD><TD>&nbsp;</TD></TR><TR><TD>7</TD><TD>May</TD><TD>AAA</TD><TD>$161,276</TD><TD>1142242</TD><TD>161276</TD><TD>&nbsp;</TD></TR><TR><TD>8</TD><TD>Jun</TD><TD>CCC</TD><TD>$257,771</TD><TD>1320740</TD><TD>257771</TD><TD>&nbsp;</TD></TR><TR><TD>8</TD><TD>Jun</TD><TD>BBB</TD><TD>$39,147</TD><TD>313033</TD><TD>39147</TD><TD>&nbsp;</TD></TR><TR><TD>8</TD><TD>Jun</TD><TD>AAA</TD><TD>$195,140</TD><TD>947102</TD><TD>195140</TD><TD>&nbsp;</TD></TR><TR><TD>9</TD><TD>Jul</TD><TD>CCC</TD><TD>$280,560</TD><TD>1040180</TD><TD>253132</TD><TD>&nbsp;</TD></TR><TR><TD>9</TD><TD>Jul</TD><TD>BBB</TD><TD>$57,266</TD><TD>255767</TD><TD>39401</TD><TD>&nbsp;</TD></TR><TR><TD>9</TD><TD>Jul</TD><TD>AAA</TD><TD>$215,752</TD><TD>731350</TD><TD>78058</TD><TD>&nbsp;</TD></TR><TR><TD>10</TD><TD>Aug</TD><TD>CCC</TD><TD>$336,528</TD><TD>703652</TD><TD>253132</TD><TD>&nbsp;</TD></TR><TR><TD>10</TD><TD>Aug</TD><TD>BBB</TD><TD>$73,255</TD><TD>182512</TD><TD>39401</TD><TD>&nbsp;</TD></TR><TR><TD>10</TD><TD>Aug</TD><TD>AAA</TD><TD>$243,131</TD><TD>488219</TD><TD>78058</TD><TD>&nbsp;</TD></TR><TR><TD>11</TD><TD>Sep</TD><TD>CCC</TD><TD>$337,392</TD><TD>366260</TD><TD>253132</TD><TD>&nbsp;</TD></TR><TR><TD>11</TD><TD>Sep</TD><TD>BBB</TD><TD>$88,453</TD><TD>94059</TD><TD>39401</TD><TD>&nbsp;</TD></TR><TR><TD>11</TD><TD>Sep</TD><TD>AAA</TD><TD>$231,547</TD><TD>256672</TD><TD>78058</TD><TD>&nbsp;</TD></TR><TR><TD>12</TD><TD>Oct</TD><TD>CCC</TD><TD>$366,260</TD><TD>0</TD><TD>253132</TD><TD>&nbsp;</TD></TR><TR><TD>12</TD><TD>Oct</TD><TD>BBB</TD><TD>$94,059</TD><TD>0</TD><TD>39401</TD><TD>&nbsp;</TD></TR><TR><TD>12</TD><TD>Oct</TD><TD>AAA</TD><TD>$256,672</TD><TD>0</TD><TD>78058</TD><TD>&nbsp;</TD></TR></TBODY></TABLE> Mon, 29 Jul 2024 16:48:32 GMT Anonymous 2024-07-29T16:48:32Z Column If condition not working for measure value. https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Column-If-condition-not-working-for-measure-value/m-p/4067498#M161475 <P>HI Team, Can you please help me with below issue.</P><P>I am calculating measure&nbsp;NovForecast as below&nbsp;</P><P>&nbsp;</P><P>NovForecast = CALCULATE('data'[TotalForecast1],FILTER('data','data'[Index]=1))</P><P>TotalForecast1 is total of current cost column as calculate function only take measure value.</P><P>&nbsp;</P><P>I am now creating column&nbsp; as&nbsp;BRMain&nbsp; but&nbsp;NovForecast value is not getting displayed in column . I am creating column BRMain as below&nbsp;</P><P>BRMain = IF('data'[Index] = 2, 'data'[NovForecast], 'data'[brCCC])<BR /><BR />Sample data is as below.</P><TABLE><TBODY><TR><TD>Index</TD><TD>Month</TD><TD>FI Name</TD><TD>Sum of Current Cost</TD><TD>Runway by CF MAIN</TD><TD>Sum of BRMain</TD><TD>NovForecast</TD></TR><TR><TD>1</TD><TD>Nov</TD><TD>CCC</TD><TD>$218,228</TD><TD>2819358</TD><TD>253132</TD><TD>218228</TD></TR><TR><TD>1</TD><TD>Nov</TD><TD>BBB</TD><TD>$3,536</TD><TD>441286</TD><TD>39401</TD><TD>3536</TD></TR><TR><TD>1</TD><TD>Nov</TD><TD>AAA</TD><TD>$210,935</TD><TD>2085510</TD><TD>78058</TD><TD>210935</TD></TR><TR><TD>2</TD><TD>Dec</TD><TD>CCC</TD><TD>$159,400</TD><TD>2659958</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>2</TD><TD>Dec</TD><TD>BBB</TD><TD>$3,097</TD><TD>438189</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>2</TD><TD>Dec</TD><TD>AAA</TD><TD>$109,713</TD><TD>1975797</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>3</TD><TD>Jan</TD><TD>CCC</TD><TD>$190,645</TD><TD>2469313</TD><TD>190645</TD><TD>&nbsp;</TD></TR><TR><TD>3</TD><TD>Jan</TD><TD>BBB</TD><TD>$15,464</TD><TD>422725</TD><TD>15464</TD><TD>&nbsp;</TD></TR><TR><TD>3</TD><TD>Jan</TD><TD>AAA</TD><TD>$167,727</TD><TD>1808070</TD><TD>167727</TD><TD>&nbsp;</TD></TR><TR><TD>4</TD><TD>Feb</TD><TD>CCC</TD><TD>$183,136</TD><TD>2286177</TD><TD>183136</TD><TD>&nbsp;</TD></TR><TR><TD>4</TD><TD>Feb</TD><TD>BBB</TD><TD>$13,541</TD><TD>409184</TD><TD>13541</TD><TD>&nbsp;</TD></TR><TR><TD>4</TD><TD>Feb</TD><TD>AAA</TD><TD>$146,721</TD><TD>1661349</TD><TD>146721</TD><TD>&nbsp;</TD></TR><TR><TD>5</TD><TD>Mar</TD><TD>CCC</TD><TD>$193,967</TD><TD>2092210</TD><TD>193967</TD><TD>&nbsp;</TD></TR><TR><TD>5</TD><TD>Mar</TD><TD>BBB</TD><TD>$19,176</TD><TD>390008</TD><TD>19176</TD><TD>&nbsp;</TD></TR><TR><TD>5</TD><TD>Mar</TD><TD>AAA</TD><TD>$169,900</TD><TD>1491449</TD><TD>169900</TD><TD>&nbsp;</TD></TR><TR><TD>6</TD><TD>Apr</TD><TD>CCC</TD><TD>$229,776</TD><TD>1862434</TD><TD>229776</TD><TD>&nbsp;</TD></TR><TR><TD>6</TD><TD>Apr</TD><TD>BBB</TD><TD>$24,984</TD><TD>365024</TD><TD>24984</TD><TD>&nbsp;</TD></TR><TR><TD>6</TD><TD>Apr</TD><TD>AAA</TD><TD>$187,931</TD><TD>1303518</TD><TD>187931</TD><TD>&nbsp;</TD></TR><TR><TD>7</TD><TD>May</TD><TD>CCC</TD><TD>$283,923</TD><TD>1578511</TD><TD>283923</TD><TD>&nbsp;</TD></TR><TR><TD>7</TD><TD>May</TD><TD>BBB</TD><TD>$12,844</TD><TD>352180</TD><TD>12844</TD><TD>&nbsp;</TD></TR><TR><TD>7</TD><TD>May</TD><TD>AAA</TD><TD>$161,276</TD><TD>1142242</TD><TD>161276</TD><TD>&nbsp;</TD></TR><TR><TD>8</TD><TD>Jun</TD><TD>CCC</TD><TD>$257,771</TD><TD>1320740</TD><TD>257771</TD><TD>&nbsp;</TD></TR><TR><TD>8</TD><TD>Jun</TD><TD>BBB</TD><TD>$39,147</TD><TD>313033</TD><TD>39147</TD><TD>&nbsp;</TD></TR><TR><TD>8</TD><TD>Jun</TD><TD>AAA</TD><TD>$195,140</TD><TD>947102</TD><TD>195140</TD><TD>&nbsp;</TD></TR><TR><TD>9</TD><TD>Jul</TD><TD>CCC</TD><TD>$280,560</TD><TD>1040180</TD><TD>253132</TD><TD>&nbsp;</TD></TR><TR><TD>9</TD><TD>Jul</TD><TD>BBB</TD><TD>$57,266</TD><TD>255767</TD><TD>39401</TD><TD>&nbsp;</TD></TR><TR><TD>9</TD><TD>Jul</TD><TD>AAA</TD><TD>$215,752</TD><TD>731350</TD><TD>78058</TD><TD>&nbsp;</TD></TR><TR><TD>10</TD><TD>Aug</TD><TD>CCC</TD><TD>$336,528</TD><TD>703652</TD><TD>253132</TD><TD>&nbsp;</TD></TR><TR><TD>10</TD><TD>Aug</TD><TD>BBB</TD><TD>$73,255</TD><TD>182512</TD><TD>39401</TD><TD>&nbsp;</TD></TR><TR><TD>10</TD><TD>Aug</TD><TD>AAA</TD><TD>$243,131</TD><TD>488219</TD><TD>78058</TD><TD>&nbsp;</TD></TR><TR><TD>11</TD><TD>Sep</TD><TD>CCC</TD><TD>$337,392</TD><TD>366260</TD><TD>253132</TD><TD>&nbsp;</TD></TR><TR><TD>11</TD><TD>Sep</TD><TD>BBB</TD><TD>$88,453</TD><TD>94059</TD><TD>39401</TD><TD>&nbsp;</TD></TR><TR><TD>11</TD><TD>Sep</TD><TD>AAA</TD><TD>$231,547</TD><TD>256672</TD><TD>78058</TD><TD>&nbsp;</TD></TR><TR><TD>12</TD><TD>Oct</TD><TD>CCC</TD><TD>$366,260</TD><TD>0</TD><TD>253132</TD><TD>&nbsp;</TD></TR><TR><TD>12</TD><TD>Oct</TD><TD>BBB</TD><TD>$94,059</TD><TD>0</TD><TD>39401</TD><TD>&nbsp;</TD></TR><TR><TD>12</TD><TD>Oct</TD><TD>AAA</TD><TD>$256,672</TD><TD>0</TD><TD>78058</TD><TD>&nbsp;</TD></TR></TBODY></TABLE> Mon, 29 Jul 2024 16:48:32 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Column-If-condition-not-working-for-measure-value/m-p/4067498#M161475 Anonymous 2024-07-29T16:48:32Z Re: Column If condition not working for measure value. https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Column-If-condition-not-working-for-measure-value/m-p/4067563#M161476 <P>I think you are telling us that <STRONG>[TotalForecast1]</STRONG> is a measure but it is not good practice to use a measure in a column. It is not advisable.</P> <P>So re-write the BRMain column.</P> <P>--</P> <P>Also, are you writing a calculated column that gets the Nov values for December rather than writing a generic LastMonthValue column?</P> Mon, 29 Jul 2024 17:43:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Column-If-condition-not-working-for-measure-value/m-p/4067563#M161476 HotChilli 2024-07-29T17:43:23Z Re: Column If condition not working for measure value. https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Column-If-condition-not-working-for-measure-value/m-p/4067570#M161477 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="81111" data-lia-user-login="HotChilli" class="lia-mention lia-mention-user">HotChilli</a>&nbsp; Thansk for your response. Can you plz advise how to write BRMain column for that IF condition</P><P><BR />Will LastMonthValue work for me coz Dec is not my last month here..</P> Mon, 29 Jul 2024 17:50:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Column-If-condition-not-working-for-measure-value/m-p/4067570#M161477 Anonymous 2024-07-29T17:50:48Z