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
The problem is I cannot select '2018-2019-2020_data'[Year], thus the question is maybe I should be accessing this data somewhat different, I have tried uploading it as a string and as a numeric value. It didn't work both times
Thats the problem, when try using IF statement, it does not detect my "Year Column", therefore, it doesnt work
