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...
Hi rokas147
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.
Best Regards,
Rico Zhou