Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
I am making a report where I have airline information like as shown. The original data contains the airport codes in 3 splitted columns. I performed Look Up on each of the rows in each column to get the Country name. I inserted calculated column names Route 1- Route 2, Route 2- Route 3. NOw the problem I am facing are (1) since this lookup and concatenation is performed in the modelling tab, I am not able to perform unpivot to bring all the Routes in the same column. Is there a way to unpivot outside Power Query? (2) To workaround, I prepared a look up table named Route and wrote a DAX code to calculate the count of routes distributed in two columns. However the values are not varying with the slicer selection since the Look up table and the master table are disconnected. What DAX will make the values vary with the change of airline name? Please help
User | Count |
---|---|
12 | |
12 | |
8 | |
8 | |
6 |
User | Count |
---|---|
27 | |
19 | |
13 | |
11 | |
7 |