cancel
Showing results for 
Search instead for 
Did you mean: 

DAX Formula produces wrong results

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: 

 

RobertBonczyk_0-1619117138243.png

 

And the correct result:

 

RobertBonczyk_1-1619117320403.png

 

 

Now, for various reasons, I need to have the YTD in columns in the datasource table, so I created custom columns in Power Query:

 

RobertBonczyk_2-1619117502315.png

 

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:

RobertBonczyk_3-1619117765797.png

 

What could be the issue here? Any help is highly appreciated.

Status: New
Comments
v-lili6-msft
Community Support

hi

First, Power Query is used to bring in source data and manipulate it for the data model. All calculations and transformations done in Power Query come into the data model as static values in Power BI. Calculated columns and measures do not flow backwards into Power Query.

 

and just from screenshots, we couldn't find the reason, could you please share your sample pbix file, that will be a great help.

 

Regards,

Lin