Hi, I want to create a formula using IF, similar to that: if(Month.'End Date'>'Switchover date','metric XX'), but I have 2 conditions:
- Month.'End Date'>'Switchover date’, and
- If it is 2022 it has to get data from metric A and if it is from 2023 onwards it has to get data from metric B
How can I do that?