Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi @Bakels1904 ,
It is strange to write a DAX like you provided. Please refer this guide of CALCULATE.
Syntax:
CALCULATE(<expression>[, <filter1> [, <filter2> [, …]]])
The first parameter is used to be aggregation functions like sum(), max(). the result of this normally is one value.
The second parameter is used to some filtered tables which result is table.
However, the result of FILTER(ItemCostPrice,max(ItemCostPrice[ToDate])-1), in your case, is table. I do not understand what you want to calculate but i think you can change CALCULATE() to CALCULATETABLE().
Or you can refer this article for more details.
If you need more help please share sample data and expect result.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Bakels1904 ,
It is strange to write a DAX like you provided. Please refer this guide of CALCULATE.
Syntax:
CALCULATE(<expression>[, <filter1> [, <filter2> [, …]]])
The first parameter is used to be aggregation functions like sum(), max(). the result of this normally is one value.
The second parameter is used to some filtered tables which result is table.
However, the result of FILTER(ItemCostPrice,max(ItemCostPrice[ToDate])-1), in your case, is table. I do not understand what you want to calculate but i think you can change CALCULATE() to CALCULATETABLE().
Or you can refer this article for more details.
If you need more help please share sample data and expect result.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HI @Bakels1904 ,
If you could share sample data in text format with expected output then people can provide you may be better approach.
You can refer to below article to get answer more quickly 🙂
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
User | Count |
---|---|
87 | |
84 | |
70 | |
62 | |
56 |
User | Count |
---|---|
137 | |
110 | |
92 | |
84 | |
69 |