Forum Discussion

DavePBI's avatar
DavePBI
Frequent Visitor
6 years ago
Solved

DAX SWITCH TRUE - help needed

Hi community / DAX experts,   I need some help here on DAX statement that I cannot get working. I have 2 tables : 1) VW_Dim_Relatie (= clients table) with a column SoortRelatie with values 00010,...
DAX Calculation
DAX SWITCH
Help me
  • az38's avatar
    az38
    6 years ago

    hi DavePBI 

    it depends on your business logic.

    you should understand what exact value you want to use for define EK for each item.

    maybe AVERAGE(), maybe SUM(). its all about task

    I dont know whats the purpose of your report, what is data nature and so on..

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Hi DavePBI 

Its because of 2 problem:

1. delimiters. You should use only ";" or "," depends on locale. I bet ";" in your case will be correct

2. double [[. use the only [SoortRelatie], not [[SoortRelatie]]