Forum Discussion
Helper ICustom Column with UseRelationship and If statement
HI jenneferparr,
It seems like you put Dax function and if statement usage into M query formulas that cause the issue.
M query is good at data structure shaping and conversations, I'd like to suggest you do these row contents calculations in Dax formula. (Notice: M query is case-sensitive, 'if' statement keyword should use 'lower' characters without '()' and it also not existed sum functions)What's the difference between DAX and Power Query (or M)?
If you confused about coding formula, please share some dummy data with a similar data structure to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Community Champion
Helper IThe two tables have an inactive relationship on the "Species_GroupID" column, and they both have an active relationship with another table on that same column.
Does that help?
HI jenneferparr,
It seems like you put Dax function and if statement usage into M query formulas that cause the issue.
M query is good at data structure shaping and conversations, I'd like to suggest you do these row contents calculations in Dax formula. (Notice: M query is case-sensitive, 'if' statement keyword should use 'lower' characters without '()' and it also not existed sum functions)What's the difference between DAX and Power Query (or M)?
If you confused about coding formula, please share some dummy data with a similar data structure to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
- jenneferparr
Anonymous thank you for that, I clearly had the usage of DAX vs M turned around. I'll try a different tactic.
Just as an aside, it sure would be helpful for those of us who can't wrap our heads around programming languages if the team behind PowerBI would pick one language for everything. But I'll take that to the suggestions forum ...