Forum Discussion
femcoldt
2 years agoFrequent Visitor
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