Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi all,
I am stuck with a DAX if someone can help me.
I have a table with 2 date columns, Column A and Column B.
I want a new column (Column C) that will look and see if there is a value in Column A, if it is blank it picks up the value from Column B. If Column A isn't blank then it populates Column C with that value. As per the table below.
TIA, Emily.
Column A | Column B | Column C |
03/02/2020 | 03/02/2020 | |
02/01/2020 | 21/01/2020 | 02/01/2020 |
13/01/2020 | 01/02/2020 | 13/01/2020 |
19/01/2020 | 03/02/2020 | 19/01/2020 |
24/12/2019 | 31/12/2019 | 24/12/2019 |
15/12/2019 | 15/12/2019 | |
30/12/2020 | 30/12/2020 |
Solved! Go to Solution.
I'm sorry I forget to add the null cases too. Try this:
if [ColumnA] = "" or [ColumnA] = null then [ColumnB] else [ColumnA]
Regards,
Happy to help!
Hi there. You should consider do this in Power Query over the query editor. If you want DAX use the first answer, if you want power query try adding a custom column like this:
if [ColumnA] = "" then [ColumnB] else [ColumnA]
Just ask if columnA is blank and you can get the true false with the columns.
Hope this helps,
Regards
Happy to help!
Hi,
Thanks for coming back to me. I'm now trying to do this in Power query but it hasn't worked. Using the add custom column option I have done:
= Table.AddColumn(#"Renamed Columns2", "Custom", each if[Column A]=""then[Column B]else[Column A])
and it isn't working. The only value that is returning in the new custom column is the value of column A.
Any ideas?
I'm sorry I forget to add the null cases too. Try this:
if [ColumnA] = "" or [ColumnA] = null then [ColumnB] else [ColumnA]
Regards,
Happy to help!
Thank you, this has worked, hurrah.
Just to build on this how would I do:
If column A and column B are blank then return todays date?
Well it should be similar
if [ColumnA] = "" or [ColumnA] = null then
if [ColumnB] = "" or [ColumnB] = null then
DateTime.LocalNow()
else [ColumnB] else [ColumnA]
You can continue adding if statements in the "then" or "else" in case you need them.
Regards,
Happy to help!
Thanks for your help.
Hi @EmilyM2019 ,
Try the following:
Date = if(isblank('Table'[ColumnA]);'Table'[ColumnB];'Table'[ColumnA])
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
31 | |
15 | |
14 | |
13 | |
9 |