Forum Discussion
Helper IVUnit of Measurement Conversions Calculated in Power Query or in DAX
Hi kewaynes, usually different units of measure are attributes of item/product. Therefore, they are part of dimensional tables (or bridge tables in case you have multiple units of measure per single item).
Do you have 4 and 20 million of products? I suppose these tables are fact tables, that contain transactional information about your items. If it's so, you can build the following data model:Then you create a measure in your report, that performs UoM conversion during the report execution.
I hope it helps! 🙂
Super UserHi kewaynes, usually different units of measure are attributes of item/product. Therefore, they are part of dimensional tables (or bridge tables in case you have multiple units of measure per single item).
Do you have 4 and 20 million of products? I suppose these tables are fact tables, that contain transactional information about your items. If it's so, you can build the following data model:
Then you create a measure in your report, that performs UoM conversion during the report execution.
I hope it helps! 🙂
Helper IVYep. This makes sense. Doing the conversion in the DAX so that it executes at query time is always what I thought the best practice was but wanted to double-check.