Forum Discussion

harshadrokade's avatar
harshadrokade
Icon for Post Partisan rankPost Partisan
4 years ago
Solved

Dax used in Table visual giving error

Hi All,   I hav ebelow data-   Student Year Exam type Subject1 Subject2 Subject3 Subject4 Subject5 ABC 31-Mar-21 Final 52 44 53 45 53 ABC 31-Mar-21 Mid 73 67 73 47 4...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

harshadrokade's avatar
harshadrokade
Icon for Post Partisan rankPost Partisan
4 years ago

Thanks a lot. I saw that & its working as expected.

 

The only issue that in case my dates table has dates as below, it brings 2021, 2020 & 2019 year value.

 

2021

2020

2018

 

I want the latest year value, previous year of latest year value & previous to previous year values from database. In above case, I want 2021, 2020 & 2018 value but its giving third year as 2019.

 

If you give me dax to get max value, max-1 value & max-2 value from database, it will be very helpful. 

 

Thanks a lot.

 

 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

Could you share a sample dataset with me where my suggested formula does not work.