Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi,
I have a requirement to calculate financial report variance which has Actual and Forecast columns, ideally variance should be Actual-Forecast but since my user is looking for a different requirement as shown below. The forecast column for Period 1 and 2 are empty so there he wants actual to be displayed also, in periods where forecast is existing irrespective of actual values present or not he wants forecast to be displayed, which is same as "2+10" row.
Please help em to create DAX for "2+10" row DAX.
Any help would be highly appreciated.
Thanks In Advance,
Neelofar Shama.
Solved! Go to Solution.
Hi @Anonymous ,
You could use the following steps:
Step1 ,import data and then transpose table, then apply and colse :
Step 2,use the following measure:
two and ten =
var test1=if(MAX('Table'[Column3])="Actual","ten and two",MAX('Table'[Column3]))
var test2=IF(test1<>BLANK(),test1,MAX('Table'[Column2]))
return test2
Wish it is helpful for you !
Best Regards
Lucien
Hi @Anonymous ,
You could use the following steps:
Step1 ,import data and then transpose table, then apply and colse :
Step 2,use the following measure:
two and ten =
var test1=if(MAX('Table'[Column3])="Actual","ten and two",MAX('Table'[Column3]))
var test2=IF(test1<>BLANK(),test1,MAX('Table'[Column2]))
return test2
Wish it is helpful for you !
Best Regards
Lucien
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
55 | |
55 | |
37 | |
30 |
User | Count |
---|---|
78 | |
64 | |
45 | |
42 | |
40 |