Old PBI files changing original states after saved

[John_Silva642]

Hello,

I will try to explain the problem I'm having. I saved the same PBI file several times, often refreshing the file in begin of each month and saving it in a folder.

But when I opened the newest PBI file I found some errors with the measures, and after taking a look at the old versions I saw that all old files are with the same error.

PS: I didn't refresh these old PBI files. When I saved the files all measures were working.

Can someone help me to solve this problem? Please.

[amitchandak]

@John_Silva642 , whar is an error? What is formula you are using?

[John_Silva642]

Hi, @amitchandak 

Appear Blank Values for some measures, and some other measures return wrong values. I'm using the CALCULATE to return the values.

But when I saved this file all measures and values were OK, without any problem.
I don't understand why these errors are appearing, I didn't refresh the file.

[amitchandak]

@John_Silva642 , This is strange. Just clear data management in Options and setting and re create the visual and check

[John_Silva642]

I cleaned the data, but the measures still return the same thing.

[v-rzhou-msft]

Hi @John_Silva642 ,

Is your issue that when you open your pbix file, your measure will show wrong result? What data source did you connect to and what kind of conntion mode die you use?

Make sure whether you have refreshed your report in Power BI Desktop. 

Please download the latest dekstop version and try again. 

Latest version : 2.100.1182.0

Please check whether you will get correct result if you try to create a same report by Power BI Desktop with the latest version.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.