Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Dax referring Excel

Hi All,

 

 I have two files country detail & Id. Result will be country & value for specific ID & code

 

Country

India

Pakistan 

Bangladesh 

Srilanka

 

Value       ID       Code

55          24          C1

42           8           C2

60           8           C3

70           25         C4

I write a Dax like

 

Country Values = 

Var Country = SelectedValues(Country)

Var India_Value = Calculate(sum(Values),Id=8,Code=C3)

Var Result = Switch(Country,"India",Indian_Value)
Return
Result

 

I have to write for more condition,for all those condition can I refer from excel file and specifiy column name in condition place will it work

 

Need Help

1 Reply

  • rajulshah's avatar
    rajulshah
    Icon for Resident Rockstar rankResident Rockstar
    3 years ago

    Anonymous ,

     

    You sure can do that, but that is not advisable. Do you have any column in tables that can be used to relate both of them? If so, you just have to write one measure, and everything would work automatically.