Forum Discussion
Average calculation
Team, I have a requirment of calculating average balances from two columns in same table looks like below my sample data Could you someone help me to get this report out i strug...
I have created new table tried working on the average , but still I am not convinced with the Logic
New Table = FILTER(
SUMMARIZE(dimDate,dimDate[Date],"BCOGS",BudgetAvgTrans[Total BCOGS],"AVGCOGS",SUM(BudgetAvgTrans[AVGCOGS])),not(ISBLANK(SUM(BudgetTrans[BCOGS]))) && NOT(ISBLANK(SUM(BudgetAvgTrans[AVGCOGS]))))
Check the file attached and let me know! Share your Kudos
