Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Power BI desktop issue

Hi

 

I am experiencing a weird issue with my PowerBI desktop.

Everytime i click on the column wiht a DAX code - it causes a break.

Tested on other PowerBI desktops and it works fine.

I also uninstalled and went back to version 2.65.5313.131

 

 

same problem.

 

Dashboards
  • Anonymous's avatar
    Anonymous
    7 years ago

    found the solution - had to add additional brackets before the IF and after

    IF(NumberOfSelectedDays=1, "", CONCATENATEX(AllButLastSelectedDay,'DimDate'[EnglishDayNameOfWeek], ", ") & " And ") & LastSelectedDay)

     

    to

     

    IF((NumberOfSelectedDays=1), "", CONCATENATEX(AllButLastSelectedDay,'DimDate'[EnglishDayNameOfWeek], ", ") & " And ") & LastSelectedDay)

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    found the solution - had to add additional brackets before the IF and after

    IF(NumberOfSelectedDays=1, "", CONCATENATEX(AllButLastSelectedDay,'DimDate'[EnglishDayNameOfWeek], ", ") & " And ") & LastSelectedDay)

     

    to

     

    IF((NumberOfSelectedDays=1), "", CONCATENATEX(AllButLastSelectedDay,'DimDate'[EnglishDayNameOfWeek], ", ") & " And ") & LastSelectedDay)