Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hi,
I needed two measures to know current year ranking and previous year ranking from the data below:
Country Name | Ranking | Year |
India | 12 | 2019 |
India | 10 | 2020 |
US | 2 | 2020 |
US | 1 | 2019 |
Please help me to achieve this.
Thanks
Solved! Go to Solution.
Proud to be a Super User!
Proud to be a Super User!
Hi @Anonymous
try
CurrentYear = CALCULATE(MAX(Table[Ranking]), Table[Year] = YEAR(TODAY()) )
and
PrevYear = CALCULATE(MAX(Table[Ranking]), Table[Year] = YEAR(TODAY())-1 )
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.