Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I am trying to convert excel report to power bi report,
=IFERROR(AVERAGEIF('Historical '!$A$3:$X$100687,'Current Year '!$A2,'Historical '!$X$3:$X$100687),"No AUP ")
Can anyone help me?
Thanks
Solved! Go to Solution.
Hi @tejapowerbi123,
There is no such a corresponding symbol that works like $ to specify a constant cell value in Power BI. We should specify a column name and hardcode the actual value inside a cell in DAX formula. The above excel formula can be converted to DAX similar to below:
New Column =
IFERROR (
CALCULATE (
AVERAGE ( TableName[Value] ),
FILTER ( TableName, <"Filter Expression"> )
),
"No AUP"
)
You should replace the underlined part with the actual filter context, like TableName[Column1]="Category1" or TableName[Column1]=TableName[Column2]
For more advice, please share sample data and show us the desired result which you have got in Excel. How to Get Your Question Answered Quickly
Best regards,
Yuliana Gu
Hi @tejapowerbi123,
There is no such a corresponding symbol that works like $ to specify a constant cell value in Power BI. We should specify a column name and hardcode the actual value inside a cell in DAX formula. The above excel formula can be converted to DAX similar to below:
New Column =
IFERROR (
CALCULATE (
AVERAGE ( TableName[Value] ),
FILTER ( TableName, <"Filter Expression"> )
),
"No AUP"
)
You should replace the underlined part with the actual filter context, like TableName[Column1]="Category1" or TableName[Column1]=TableName[Column2]
For more advice, please share sample data and show us the desired result which you have got in Excel. How to Get Your Question Answered Quickly
Best regards,
Yuliana Gu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |