Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
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?
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..
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
7 | |
7 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |