Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good day.
The data source is Salesforce report. From a column (column Travel Date), I added a new column to show the latest date from Column Travel Date. the DAX is: Latest Travel Date = MAX(temm[Travel Date]).
When the Data Type of the column Travel Date is set to Text. The new column returns: 30/04/2019.
When the Data Type of the column Travel Date is set to Date. The new column returns: 2019-12-04.
But actually the latest date from the column Travel Date is 08 May 2019.
I suspect something wrong with the data format from Salesforce report.
What’s the way to have it correctly shown in Power BI?
Thank you.
Solved! Go to Solution.
Hi @JohnDahis ,
Please check if the date format of [Travel Date] is different in Salesforce report and in Power BI desktop. The change between "MM/dd/yyyy" and "dd/MM/yyyy" might cause the wrong result when dong calculation.
Reference:
Local date formats in Power BI
Date issue - dd/mm/yyyy vs mm/dd/yyyy
Best regards,
Yuliana Gu
Hi @JohnDahis ,
Please check if the date format of [Travel Date] is different in Salesforce report and in Power BI desktop. The change between "MM/dd/yyyy" and "dd/MM/yyyy" might cause the wrong result when dong calculation.
Reference:
Local date formats in Power BI
Date issue - dd/mm/yyyy vs mm/dd/yyyy
Best regards,
Yuliana Gu
@v-yulgu-msft thank you, Yuliana. "Region" setting on local computer might be the root cause of this problem.
Try to reload the table again and try. DAX is perfect
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |