Forum Discussion
DAX makes me crazy : CONVERT
Hello again 🙂
Finally I made all work this morning at 4AM (CET). The
"attribute" = CONVERT(column, STRING)
has been replaced by a
"attribute" = column & ""
...Something I use to do when I do not have the choice to use a var typed variable. Not clean but it works.
I had a second issue coming from 2 other columns (one in each SharePoint list) that are search typed, with the same source. As I explained, it works until I edit the DAX script but I needed to change something in it, so I took 2 attributes with a different name (instead of the same one to be taken into account by the NATURALLEFTOUTERJOIN), and I added a FILTER on [attribute1] = [attribute2].
Now I can finish the v2 of my dashboards.
Many thanks, again, for your advice about Power Query. Be sure this is something I will work on once the reports will be published (even if I do not eat caviar anymore since I discovered the female fishs were opened alive to get the eggs, then thrown back into the sea still alive but dying, thanks to humanity) !
Thanks again !
B.R.
Eric
Community ChampionI once did what you do now, considering DAX as a cure-all until I found PQ (the Mashup language to be exact) is another caviar in PBI.
Like what you mentioned, PQ desguises with a low/no code UI😀; but its real power lies in its script editor. At least 90% of complicated missions of data ETL are to accomplish there.
Hello again 🙂
Finally I made all work this morning at 4AM (CET). The
"attribute" = CONVERT(column, STRING)
has been replaced by a
"attribute" = column & ""
...Something I use to do when I do not have the choice to use a var typed variable. Not clean but it works.
I had a second issue coming from 2 other columns (one in each SharePoint list) that are search typed, with the same source. As I explained, it works until I edit the DAX script but I needed to change something in it, so I took 2 attributes with a different name (instead of the same one to be taken into account by the NATURALLEFTOUTERJOIN), and I added a FILTER on [attribute1] = [attribute2].
Now I can finish the v2 of my dashboards.
Many thanks, again, for your advice about Power Query. Be sure this is something I will work on once the reports will be published (even if I do not eat caviar anymore since I discovered the female fishs were opened alive to get the eggs, then thrown back into the sea still alive but dying, thanks to humanity) !
Thanks again !
B.R.
Eric