Report Portal

Show facts in different measurements using DAX and PowerPivot

Yesterday got a question where a customer pulled a raw fact table into a Tabular model, the customer would like to take a look at all the orders by the customer in different measurements. The multiple measurements are stored in the Material Master table, so if the customer wishes to report items in Cases, Pallets, Cubic meters, etc they can do so. This straight forward in DAX but I still decided to do a blog post instead of answering in an email as this might help others.

Read more...

Tags: dax, tabular

 

2007-2015 VidasSoft Systems Inc.