Forum Discussion
"Compute Using" option
Like "Compute Using" option is present in tableau for doing calculations across table, across pane etc, is there any similar feature in power bi?
Matt,
Is there a simple way of calculating the running total... I am also trying to draw a pareto chart
Quick and Versatile are often strangers. Power BI is very versitile, but not so quick. You can write a formula for a running total like this.
=calculate(sum(table[qty],
filter(all(calendar),
calendar[date] <= max(calendar[date])
)
)
this may or may not be what you are after I guess, but it will create a running total.
If you read my book and do the exercises, you will be on your way to becoming a DAX Ninja :-)