Hello, here - for the calculation of measure CY Sales we need to use the field 'Fiscal_Year' which has data from Jan till latest month-Year available in the app and for the calculation of the measure ' Complete TGT' we need to use the field 'Year' which has data for all months from Jan to Dec since Complete TGT means Target for the whole year. These two measures are placed in a single table...so I need solution for this how to display both measures dynamically according to the user selection for years -2021,2022,2023
Eg.
Year |
CY Sales |
Complete TGT |
2021 |
100 |
500 |
2022 |
200 |
600 |
2023 |
300 |
450 |