Forum Discussion

gayle_t's avatar
gayle_t
Regular Visitor
9 years ago

Sumx and currency conversion doesnt return correct results

Hi Trying to do a simple currency conversion of a measure.   Measure_Convert := sumx(Data_all, DIVIDE([TotalRevenue], [Exchange Rate])   TotalRevenue is measure that uses calculate with a few co...
Need Help
v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

gayle_t

 

As BhaveshPatel said, you’d better post snapshot of your data model and sample data. I tested with following two simple tables (“Data_all” and “Exchange_Rates” have relationship with “ID” key) and didn’t experience the problem you mentioned above.

 

 

Best Regards,

Herbert

gayle_t's avatar
gayle_t
Regular Visitor
9 years ago

Thanks v-haibl-msft and BhaveshPatel

 

Unfortunately my data is confidential, dont think i can post here. I would need to randomise the data and see whether the issue still persists.

 

I will post the data model and samples soon.