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

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,