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.

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

Hi harshadrokade ,

The Error says the column that you have used in the DATEADD() function is not having continuous dates and there are gaps in the column

 

Can you chk on it?

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

Thanks Thejeswar . I could see that but my data is that way only. The data is not continous & there are gaps in dates, I can;t change that.

Can you pls suggest me a correct measure (Instead of Datesadd) that will give me correct values with available data?