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.
Hi,
I am trying to create a column that will return the date from two columns if one is blank.
The two columns are Trans Date and Sett Date. Trans Date always has a date however i would like to use Sett Date unless it is Blank?
I have tried to create a column using this Dax
Solved! Go to Solution.
Hi. The error seems to be about one of those columns. Check their data type because one of them might be type text and the other date. Make sure they are both date (change them in the edit queries / transform data menu). You can read more about this here:
https://docs.microsoft.com/en-us/power-bi/desktop-data-types
After having the same data types your dax should work. However you mention you want to ask about blank, so you should try this:
NewColumn =
IF(
ISBLANK(Table[SETT_DATE]),
Table[TRANS_DATE],
Table[SETT_DATE]
)
Hope this helps,
Happy to help!
Hi. The error seems to be about one of those columns. Check their data type because one of them might be type text and the other date. Make sure they are both date (change them in the edit queries / transform data menu). You can read more about this here:
https://docs.microsoft.com/en-us/power-bi/desktop-data-types
After having the same data types your dax should work. However you mention you want to ask about blank, so you should try this:
NewColumn =
IF(
ISBLANK(Table[SETT_DATE]),
Table[TRANS_DATE],
Table[SETT_DATE]
)
Hope this helps,
Happy to help!
Thanks @ibarrau you were correct. One of the columns wasnt set as a date in the data type!
once i changed that my Dax worked!
Thanks!
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 |
---|---|
43 | |
20 | |
18 | |
16 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |