Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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[Date]))
PY Amount = CALCULATE(Amt,SAMEPERIODLASTYEAR(DATE[Date]))
PYTD Amount = CALCULATE(PY Amount,DATESYTD(DATE[Date]))
Dragged 2 visuals that is Slicer and Table. when i select slicer from 1/1/2020 and 2/25/2020. But Power BI Desktop and Excel both are showinf correct values. for 2/26 is not showing the right values in Desktop. Hoping that the DAX function is not working.
Solved! Go to Solution.
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.
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
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.