How to mark completion date of a task but not change based on system clock when refresh data.

[Nhphong]

Hello,

Currently, I have two columns in table, i want to mark completion date when the percentage column reaches to 100%.

I used daxfunction: IF('Completion Date'[% Done chuyen may]=1,TODAY(),BLANK())

Problem: When refreshing data, completion date changes to system clock date. How can i avoid this ? I also used Now() function but the result still the same as with Today().

Regards,

Hoai Phong

[Nhphong]

Hi,

The Percentage column is calculated by two cloumns are: Quantity of complete/Total. When complete = Total then 100%.

Regards,

Hoai Phong

[MohammadLoran25]

Okay.

And your Complete and Total Columns are read from direct query or Imported from SQL? How they are loaded?

[Nhphong]

Hi sir,

My data source is excel file from sharepoint. People keyin status "Done" after complete.

[MohammadLoran25]

Hi,

What is your data source? The Percentage column is read from your data source directly (Direct Query etc.) or it is calculated using a calculation in power bi?