Forum Discussion
Sum using conditions
Hi, I have 5 columns with Date, Week no, Sales Channel, Website and Values. PPC Last WTD Spend = CALCULATE(SUM('ALL_WTD'[Value]),'ALL_WTD'[WTD]="Last WTD", 'ALL_WTD'[Funnel]="Spend", 'ALL_WTD'[C...
Hi,
Would you be able to post some of your data (or make some up if it's sensitive/confidential) so that we can help, along with what your expected result would be?
Thanks
Alex
Hi Alex,
Many thanks. I will send the data next week when I am back. I am trying to switch from tableau to power bi but I think I need to work on my DAX quite a bit before I build something useful for the cheifs at work. have a nice weekend. :)