Export to Excel Not Working Properly for Measure with SAMEPERIODLASTYEAR

[prashantpattnai]

Hi All,

Greetings!

I have a measure as below. This works fine with a calendar date slicer. However, upon exporting to excel it shows 0% in all rows. Not sure if I'm missing anything here.

Previous Year Rate = CALCULATE([This Year Rate], SAMEPERIODLASTYEAR(CalendarDate[Date]) )

Report design specs:: Line Chart with Calendar Hierarchy (Year->Qtr->Month) in Axis, [This Year Rate] and [Previous Year Rate] measure in values.

Note: Both the measures are in % format.

Any help is appreciated.

Thanks.

[v-qiuyu-msft]

Hi @prashantpattnai,

From your DAX, I see [This Year Rate] should be a measure also, how did you define this measure? Have you tried the export to data feature in Power BI desktop, is there the same issue happens? Can you share the sample data or .pbix file for us to test on our side?

Best Regards,
Qiuyun Yu

[prashantpattnai]

@v-qiuyu-msft Yes, both [This Year Rate] and [Previous Year Rate] are measures. I tried to export data from both Power BI desktop and service, both showing the same result in export. In chart [This Year Rate] and [Previous Year Rate] shows valid numbers but in export only [This Year Rate] shows the valid number and [Previous Year Rate] shows 0%.

Not sure if I can share the .pbix file as it has business sensitive information. Will update you on sharing .pbix file. How about to have a screen share if possible?

Thanks