Selecting Column Data Across 2 Columns

To achieve this in Power BI, you can create a new calculated column using DAX expressions. Here's how you can create the third date column based on the conditions you provided:

Third Date Column =
IF(
ISBLANK([CONC]),
IF(
ISBLANK([FAD]),
TODAY(),
[FAD]
),
[CONC]
)

Let's break down the logic:

• If the CONC column is blank, it checks if the FAD column is blank. If the FAD column is blank, it returns today's date using the TODAY() function. If the FAD column contains a date, it returns the date from the FAD column.

• If the CONC column contains a date, it returns the date from the CONC column.

This calculated column will contain the dates based on the conditions you specified. You can adjust the column names as per your actual column names in your Power BI dataset.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

In case there is still a problem, please feel free and explain your issue in detail, It will be my pleasure to assist you in any way I can.