Forum Discussion

femcoldt's avatar
femcoldt
Frequent Visitor
2 years ago

Need help with DAX

Hi everyone,  I am in a situation. the screen shot below is in excel, i have all the measures except for the ones in the red rectange. I am fighiting to get a way to calcualte this in powerbi. 

 

the YOY in excel is calculated as =SUM(K8/K3)-1

Quaterly YOY is calculated as =(SUM(K8:M8)/SUM(K3:M3))-1

YTD/YTG is calculated as =(SUM(K8:M8)/SUM(K3:M3))-1.

 

Any help is appreciated