Hello Everyone,
I am looking for a dax function measure for powerpivot report which would return the value based on a lookup value from different table.
For Example,I have 2 tables as follows
<tbody>
</tbody>
<tbody>
</tbody>
The logic for the function i am looking for would be
if city name pertains to State_Code = MH then Tax Rate Would be 20%,
if city name pertains to State_Code = TM then Tax Rate Would be 18%
if city name pertains to State_Code = UP then Tax Rate Would be 15%
I dont want a calculated column, i want to create a dax measure for tax value.
Thank you so much in advance.
Best Regards
Shib
I am looking for a dax function measure for powerpivot report which would return the value based on a lookup value from different table.
For Example,I have 2 tables as follows
City Name | State_Code |
Mumbai | MH |
Pune | MH |
Chennai | TM |
Noida | UP |
<tbody>
</tbody>
Product_Name | City | Price |
Computer | Mumbai | 100000 |
Computer | Noida | 70000 |
Computer | Chennai | 80000 |
Computer | Pune | 60000 |
<tbody>
</tbody>
The logic for the function i am looking for would be
if city name pertains to State_Code = MH then Tax Rate Would be 20%,
if city name pertains to State_Code = TM then Tax Rate Would be 18%
if city name pertains to State_Code = UP then Tax Rate Would be 15%
I dont want a calculated column, i want to create a dax measure for tax value.
Thank you so much in advance.
Best Regards
Shib
Last edited: