Forum Discussion

prashantpattnai's avatar
prashantpattnai
Frequent Visitor
9 years ago

Export to Excel Not Working Properly for Measure with SAMEPERIODLASTYEAR

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. Previ...
Tips and Tricks
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

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's avatar
prashantpattnai
Frequent Visitor
9 years ago

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