Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello, I hope I can get some help on this Problem.
There is a logic where if the value in a column changes from "No" to "yes" then we need to record today's date and if some rows changes in different date it should show that date.
client | Present | the date that changed from No to yes |
A | Yes | 8/12/2022 |
B | No | blank |
C | Yes | 8/13/2022 ( if the Present will change from No to yes tomorrow then display tomorrow's date. |
We were able to create a formula by using
test = If ( Present= Yes, today()) but it just shows all the dates in today's date without saving the previous record.
how can we do that where we can save the date as the changes happen?
I would really appreciate it if you can help with this.
Thank you for your time.
Solved! Go to Solution.
Im not sure if this is possible in Power BI only.
This needs to be taken care of outside Power BI.
If this is stored via Sharepoint list this is possible since you can just look at the modified date.
Im not sure if this is possible in Power BI only.
This needs to be taken care of outside Power BI.
If this is stored via Sharepoint list this is possible since you can just look at the modified date.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |