Report Portal

DAX: Calculating different rates on user defined inputs

A few weeks ago a client asked me an interesting question. They had a table of data, and they wanted to pass in (in their words) a variable in order to change the calculated value. I'd played around with banding before (see my post here), but I hadn't been able to play with something quite as specific as the scenario they presented. To outline the issue, let's say we have a user created table that consists of the different pricing tiers for our customers, similar to the below:

Read more...

Tags: dax, tabular

 

2007-2015 VidasSoft Systems Inc.