Forum Discussion
Table Calculations
Hello! I'm trying to recreate a Tableau report in Power BI. The report has many table calculations using Window_Sum(), Window_Avg() and Lookup(). Is there a way to perfrom these calculations in P...
I am also searching for an answer to this. Tableau Table Calculations are calculations run AFTER an initial aggregation in a visualization.
So, say you SUM sales by customer. You can then run the equivalent of a window function across that whole result set or partitions in that result set. They are directly analogous to window functions in SQL.
I am not aware of something that lets you do this in PowerBI dynamically in a table -- for instance, a running sum along a discrete dimension that responds to the user changing the sort order.