structured references
1 Topic
Excel to DAX: converting SUMIFS structured references ([column1],[@[column1])
Greetings! I am trying to transition an excel workboook with several types of calculations to Power BI. In particular, I am struggling with how to replicate a conditional SUMIFS calculation that uses structured references. The excel expression is: =SUMIFS([Column1],[Column2],[@Column2],[Column3],[@[Column3]]) In DAX, how can I sum the values of column 1 given specific row values in columns 2 and 3? I realize that the DAX framework is based on table/column/row refernece and not cell references (like excel), but I'm not making the intellectual leap here. Any help would be appreciated!Solved1.8KViews0likes6Comments