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.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
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 Ashish_Mathur . I saw that the calendar year table has year only till 2021. my data will keep adding for upcoming years liek 2022, 2023 & so on.. 

In that case I want the latest year to be considered as per latest data & not 2021. How to manage that sir. Pls help.

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

    You are welcome.  The Calendar Table will auto extend as data gets added to the Data Table.

    • 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.

  • Thejeswar's avatar
    Thejeswar
    Icon for Super User rankSuper User
    4 years ago

    Hi harshadrokade ,

    You can use a CALENDARAUTO() function, instead of CALENDAR() to auto extend the dates without doing anything in the upcoming years. 

     

    Regards,