Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
87 | |
72 | |
69 | |
64 | |
54 |
User | Count |
---|---|
99 | |
91 | |
80 | |
74 | |
64 |