Forum Discussion
If statement with year
Hi all, this is the problem I am facing. I have 3 years, 2018, 2019 and 2020. The formula I am using: Case study calculated = IF('2018-2019-2020_data'[Year]="2020",(SUM('2018-2019-2020_dat...
Why not create a calculated column in your table ?
CaseStudiesCalculated =
IF('2018-2019-2020_data'[Year]="2020",'2018-2019-2020_data'[Case studies])/0.67*'Case Study discount'[Case Study discount Value]/100),SUM('2018-2019-2020_data'[Case studies])
Then show the SUM of column in your visual
Thats the problem, when try using IF statement, it does not detect my "Year Column", therefore, it doesnt work