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.
Hi Community,
when I create custom columns in Power Query, they produce different (wrong) results from when I create a measure that should result in the same result.
Example:
I only have Actual costs per month, but I want to create a YTD column. My Measure would look like this:
And the correct result:
Now, for various reasons, I need to have the YTD in columns in the datasource table, so I created custom columns in Power Query:
Not the most elegant method, but it should do the trick for now. I basically just sum the respective month per column. So for YTD February I sum January and February.
However, this is the result:
What could be the issue here? Any help is highly appreciated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.