Forum Discussion

venal's avatar
venal
Memorable Member
6 years ago
Solved

DAX Function is not working

Hello Folks,   I tried to create a sample report with table visual, but one value is showing wrong values.   Column Names:- Date, Amount Amt=SUM(Amount) YTD Amount= CALCULATE(Amt,DATESYTD(DATE[...
Need Help
  • venal's avatar
    venal
    6 years ago

    v-easonf-msft 

    Thanks for the response.

    2/26 is not shoiwng correct values in Excel and Power BI Desktop.

    Found the work-around with CALENDARAUTO() DAX Function and created a relationship for the 2 date columns.

    Now it is showing as expected in both sides.

    Thanks once again for your support.

    GilbertQ ,v-easonf-msft - Thank you.

     

venal's avatar
venal
Memorable Member
6 years ago

Uploaded the sample data with PBIX.

 

PBIX

 

Excel

v-easonf-msft's avatar
v-easonf-msft
Community Support
6 years ago

Hi , venal 

I open  the pbix your gave.

And it shows as below.

 

I don't quite understand the word  you mean  that "for 2/26 is not showing the right values in Desktop." .

Could your please tell me more details.


Best Regards,
Community Support Team _ Eason

  • venal's avatar
    venal
    Memorable Member
    6 years ago

    v-easonf-msft 

    Thanks for the response.

    2/26 is not shoiwng correct values in Excel and Power BI Desktop.

    Found the work-around with CALENDARAUTO() DAX Function and created a relationship for the 2 date columns.

    Now it is showing as expected in both sides.

    Thanks once again for your support.

    GilbertQ ,v-easonf-msft - Thank you.