Forum Discussion

markefrody's avatar
markefrody
Icon for Post Patron rankPost Patron
2 years ago
Solved

Cannot Select Columns or Other Tables

Hi,   I am trying to compute the days difference between two dates using DAX. These two dates are located in different tables. The problem is when I input the DAX it does not show the other table a...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi  markefrody,

    It doesn't seem to have anything to do with relationships. Calculated columns are suitable for single-table calculations. As shown in the figure, you created in Table 1, so all the fields in Table 1 are included. So you need to use measure to do that.

    Hope it helps!

    Best regards,
    Community Support Team_ Tom Shen

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