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.
My requirement is to add data into the blank row. My data is
Creation date | Creation from system | Deleting |
12/5/2016 | 12/5/2016 | |
13/5/2016 | ||
14/5/2016 | ||
15/1/2016 | 15/6/2017 | |
16/1/2016 | 16/6/2017 | |
16/1/2016 | 17/6/2017 | |
12/4/2017 | ||
13/4/2017 | ||
14/4/2017 | ||
16/1/2016 | 16/4/2018 | |
12/2/2017 | ||
12/2/2017 | ||
12/2/2017 | ||
12/2/2017 | ||
12/2/2017 | ||
12/2/2017 |
Creation date(In the first column) is from manual adding. We can't collect some data so we need to get the date from the system. (Second column) We found more data but something has deleted from the system then we lose some data too. So we want to merge the data that empty from the system to get all of the data (Not merge). Like in the picture
And this is the result.
Creation date | Creation from system | Deleting |
12/5/2016 | 12/5/2016 | |
13/5/2016 | ||
14/5/2016 | ||
15/1/2016 | 15/1/2016 | 15/6/2017 |
16/1/2016 | 16/1/2016 | 16/6/2017 |
16/1/2016 | 16/1/2016 | 17/6/2017 |
12/4/2017 | ||
13/4/2017 | ||
14/4/2017 | ||
16/1/2016 | 17/1/2016 | 16/4/2018 |
12/2/2017 | ||
12/2/2017 | ||
12/2/2017 | ||
12/2/2017 | ||
12/2/2017 | ||
12/2/2017 |
Can I do this in Power BI? Could you please suggest me hot to do this in DAX?
Thank you all.
Solved! Go to Solution.
Hi @saranp780,
You could create a calculated column with the formula below.
Column 2 = 'table'[Creation from system] & IF ( ISBLANK ( 'table'[Creation from system] ), 'table'[Creation date] )
Here is the output.
Hope this can help you!
Best Regards,
Cherry
Hi @saranp780,
You could create a calculated column with the formula below.
Column 2 = 'table'[Creation from system] & IF ( ISBLANK ( 'table'[Creation from system] ), 'table'[Creation date] )
Here is the output.
Hope this can help you!
Best Regards,
Cherry
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 | |
88 | |
63 |