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?