Forum Discussion
Exporting summarized data does not include lines where the measure is the same as the previous line
- 3 years ago
Hi , sg1234
According to your description, you use a measure to get the rolling sum of the value per period and you export it to excel/csv in Power BI Service.
And you find that the same value and 0 do not display in the excel .
I test it in my side , this is my test data:
And i create a measure to test:
And when i export it to excel , the data is all display :
What I want to say is that the export of Power Bi Service is the default behavior, and we have no place to modify the export result of this behavior.
And in my test, I exported the corresponding data, and I don't know how you achieve your Measure. If I need me to help you test, you can use your Sample PBix (delete sensitive data).
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi , sg1234
According to your description, you use a measure to get the rolling sum of the value per period and you export it to excel/csv in Power BI Service.
And you find that the same value and 0 do not display in the excel .
I test it in my side , this is my test data:
And i create a measure to test:
And when i export it to excel , the data is all display :
What I want to say is that the export of Power Bi Service is the default behavior, and we have no place to modify the export result of this behavior.
And in my test, I exported the corresponding data, and I don't know how you achieve your Measure. If I need me to help you test, you can use your Sample PBix (delete sensitive data).
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly