Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
For those much more familiar with Excel than PowerBI, I've used the following as an Excel equivalent for a simple way of conducting a weighted average calculation (similar to a simple SUMPRODUCT)
_SUMPRODUCT example =
VAR _DESIREDROWS =
FILTER (
[Table Name],
[Column of Data to filter on] > [filter metric]
)
RETURN
DIVIDE (
SUMX (
_DESIREDROWS,
[Value] * [Unit weighting]
),
SUMX (
_DESIREDROWS,
[Unit weighting]
)
)
The above portion allows one to filter the data to a certain criteria, and the lower allows to calculate a weighted average, say for a baseball team's batting average.
What would be the equivalent measure for INDEX MATCH?
for example, let's say one had a baseball team of players with a typical matrix of various statistical categories - batting average, home runs, etc.
In Excel, the programming would be =INDEX([entire table],MATCH( {player name},[column of player names],0),MATCH ( {statistical category}, [row of statistical categories],0))
Solved! Go to Solution.
@mrothschild I put together an Excel to DAX translation series which might help:
Excel to DAX Translation - Microsoft Power BI Community
@mrothschild I put together an Excel to DAX translation series which might help:
Excel to DAX Translation - Microsoft Power BI Community
AH - MAZING!
I started learning PowerBI and DAX almost 3 years ago, and how I wished that guide was around when I was first learning - but so happy that I know about it now! I think it will help me go much further.
Thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |