Trying to calculate change over time using a SUMX function with DAX. but the value I get is cumulative value–how can I get the non-cumulative value?
I have a dataset that looks something like this:
Build a visual with KPIs from different tables
There is a report that is currently in Excel but I’d like to move it to Power BI:
Create SUMPRODUCT formula from excel to DAX Measure Power BI
I’ve created a formula in excel : =SUMPRODUCT(AK14:AK37,AM14:AM37) that gives a result of 98.77%(converted to percentage). I tried using sumx function and it works only in when applied in a matrix(filter context) but not in the total.
Excel: