Forum Discussion
M Query Equivalent to DAX Calculated Columns
Hi Anonymous ,
Power Query can do all of this if you push it hard enough, but the query would be disproportionally complicated and would take a week to refresh.
Power Query/M is just not designed for what you are wanting it to do here, DAX is.
Your original path appears to be the correct one from the limited info I have. The only comment I would make on what you have done so far would be to say that DAX calculated columns should only be used as a very last resort. They have to be materialised in-memory at runtime so can cause significant performance degradation.
The calculated columns you described should be recreated as measures.
Pete
Hi Anonymous ,
Power Query can do all of this if you push it hard enough, but the query would be disproportionally complicated and would take a week to refresh.
Power Query/M is just not designed for what you are wanting it to do here, DAX is.
Your original path appears to be the correct one from the limited info I have. The only comment I would make on what you have done so far would be to say that DAX calculated columns should only be used as a very last resort. They have to be materialised in-memory at runtime so can cause significant performance degradation.
The calculated columns you described should be recreated as measures.
Pete
Hi BA_Pete , many thanks for that, your anser was pretty much what i was expecting. Totally agree in creating measures rather than the calc columns, my viewpoint was to create a table of the proportioned data to show an end result. I think in the end calculated measures may be my answer.
Regards Mike.