Forum Discussion
dean_rowntree
7 years agoRegular Visitor
Difference between PowerBI and Powery Query in Excel with same data
Hello I am trying to create a cumulative flow diagram in PowerBi, but my data is not giving me the results I expected. I recreated it in Power Query and got the result I expected. Here is the...
Anonymous
7 years agoNot applicable
HI dean_rowntree,
I guest this issue may related to power query lazy evaluation, you can take a look at following links about this:
On lazy value evaluation order in Power Query and Power BI
Power Query M Primer (Part 5): Paradigm
Regards,
Xiaoxin Sheng
- dean_rowntree7 years agoRegular Visitor
Thank you for the information, but I don't understand how the same code can produce different reults from the same source data, with the only difference being the application the code is executed in.
- Anonymous7 years agoNot applicable
HI dean_rowntree,
I also not so sure for the internal calculation logic, maybe you can submit a support ticket to get better support from dev team.
Regards,
Xiaoxin Sheng
- dean_rowntree7 years agoRegular Visitor
Thank you for the suggestion, I may try that if I can figure out how to do so.