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.
Hi,
I'm working on a POWER BI project to analyse ERP data connecting POWER BI to SQL.
For my accounting service i need to user POWER BI PUBLISHER for Excel.
But i've an issue with the date format in the PB Builder it's fine, Excel dont reconize the date format ... :
Could you please help me ? Did i do something wrong ?
Thank's for your help !
Ben
Solved! Go to Solution.
Hi V-Ljerr,
Thanks for your answer.
I just try to update my Windows 10, Power BI Desktop and Power BI Publisher but still the same issue 😞 ... it look like a date format but it's not :
I tried to connect POWER QUERY for Excel strait to my SQL Database to compare and the result is not the same ! I have date +year / month date automaticaly and i can use chronology function :
To move forward i created a calendar dimension table in power bi with the following DAX expression and i linked it with my other table to filter data. It works fine 😉 :
CALENDRIER = ADDCOLUMNS (CALENDAR(DATE(2010;1;1); DATE(2020;12;31)); "Année"; YEAR ( [Date] ); "N° Mois"; FORMAT ( [Date]; "MM" ); "Mois"; FORMAT ( [Date]; "mmm" ); "N°Semaine"; WEEKDAY ( [Date] ); "Jour"; FORMAT ( [Date]; "dddd" ); "Trimestre"; "T" & FORMAT ( [Date]; "Q" ))
Thanks for your help !
Ben
Hi V-Ljerr,
Thanks for your answer.
I just try to update my Windows 10, Power BI Desktop and Power BI Publisher but still the same issue 😞 ... it look like a date format but it's not :
I tried to connect POWER QUERY for Excel strait to my SQL Database to compare and the result is not the same ! I have date +year / month date automaticaly and i can use chronology function :
To move forward i created a calendar dimension table in power bi with the following DAX expression and i linked it with my other table to filter data. It works fine 😉 :
CALENDRIER = ADDCOLUMNS (CALENDAR(DATE(2010;1;1); DATE(2020;12;31)); "Année"; YEAR ( [Date] ); "N° Mois"; FORMAT ( [Date]; "MM" ); "Mois"; FORMAT ( [Date]; "mmm" ); "N°Semaine"; WEEKDAY ( [Date] ); "Jour"; FORMAT ( [Date]; "dddd" ); "Trimestre"; "T" & FORMAT ( [Date]; "Q" ))
Thanks for your help !
Ben
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |