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.
This may be a very basic question, but I want to add two columns together, and one column has a null value for now. I know I can add them together by replacing all the null values with 0. My question is if the field is updated in Salesforce, will that value still be 0? Or will it change to the updated value?
Thanks!
Solved! Go to Solution.
Once the Salesforce data is updated, then, upon refresh, the null will be something not null and thus your addition would be that non-null value plus your other, presumably non-null value and thus your first non-null value would be non-zero (assuming your IF logic is correct) and thus the updated value.
Once the Salesforce data is updated, then, upon refresh, the null will be something not null and thus your addition would be that non-null value plus your other, presumably non-null value and thus your first non-null value would be non-zero (assuming your IF logic is correct) and thus the updated value.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |