Forum Discussion
dax Time based calculations in PowerBI are incorrect when exporting data from visualization
dax Time based calculations in PowerBI are incorrect when exporting data from visualization. The time based measures are correct in Power BI visualizations but when you export data they are incorrect in the excel exported file.
3 Replies
- Greg_Deckler
Community Champion
Can you provide a specific example that can be recreated?
I created grid visualization and the totals matches in Power BI. I exported the visualization and the sum up the column in excel and they don't match. The measures used are dax formulas based on the time ytd and pyytd calculazations.
Power BI grid visualization
Exported data and filtered out blanks and the totals don’t match
