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.

     

GilbertQ's avatar
GilbertQ
Super User
6 years ago
Hi there

How are you getting the date 2/26 if you are using a datetime based on NOW() or UTCNOW() this is based in UTC and depending on where you are in the world will show you based on UTC.

If you had to exclude 2/26 are the values correct?
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.