Forum Discussion
Translating Sheet Formulas into DAX
Hi, Yrstruly2021
I would like to ask if an error occurred during operation? Do you need to check the calculation logic?Here are some of the results I checked:
Cash flow from ops – management maybe wrong:
Working capital mvts excl. provisions maybe wrong:
The following two columns did not find the corresponding columns:
I have checked part of it, the specific results are as follows:
Not found means that the method was not found in the PBIX file, No means that the condition is missing, or the usage is inconsistent with the one in Excel.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for the reply. The missing "columns" refer to the numeric values i removed due to privacy. Those are the only two columns that are missing, so my calculations shows errors when those columns are removed. No, my PBIX file ran without any errors. I just need to make sue that the first metric as mentioned are calcullated correctly. Why do you say these two(Cash flow from ops – management maybe wrong, Working capital mvts excl. provisions ) might be wrong?