Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Using Power BI data set as source for Excel pivot table

Hi,    I have a problem when using Power BI data set as source for Excel pivot table. When adding date in the pivot table, dates are formated as text (e.g. "02/01/2019"), but in Power BI it is cor...
Need Help
Anais_M's avatar
Anais_M
New Member
2 years ago

Hello, 

Just create 3 new columns in your Date table : Year = YEAR(DimDate[Date]), Month et Day, in DAX, and you're good to go.