dax Time based calculations in PowerBI are incorrect when exporting data from visualization

[hhmeadow]

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.

[hhmeadow]

Power BI grid visualization

Exported data and filtered out blanks and the totals don’t match

[Greg_Deckler]

Can you provide a specific example that can be recreated?

[hhmeadow]

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.