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 have the following question.
I have users who have the ability to enter data via a Power App.
I need for every project one row.
The rule can be defined as follow : Every new input overwrites the old value. Only overwrite if the value isn't blank.
Expected output from the file:
Project | Budget | Level |
100 | 100 | 1 |
300 | 300 | 1 |
Thanks in advance,
Ronald
Link : https://1drv.ms/u/s!An5X7wdH9O9ejlFXihAv_VuMcUBX
Solved! Go to Solution.
Hi @Ronald123 ,
In Power Query, seems that there is not a 'overwrite' definition but 'Replace values' or 'Refresh', not certain what did you want based on your description.
If you want to replace values, please refer this article: Override-values-with-formula-using-power-query
Compared with the expected output and the sample file, 'overwrite if the value isn't blank.' seems not clear that for which column value is not blank or all column values are not blnak to replace values.
Best Regards,
Community Support Team _ Yingjie Li
Hi @Ronald123 ,
In Power Query, seems that there is not a 'overwrite' definition but 'Replace values' or 'Refresh', not certain what did you want based on your description.
If you want to replace values, please refer this article: Override-values-with-formula-using-power-query
Compared with the expected output and the sample file, 'overwrite if the value isn't blank.' seems not clear that for which column value is not blank or all column values are not blnak to replace values.
Best Regards,
Community Support Team _ Yingjie Li
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 |
---|---|
101 | |
50 | |
19 | |
12 | |
11 |