Forum Discussion

marksappleton's avatar
marksappleton
Frequent Visitor
8 years ago
Solved

Need help: Date indicator column

Hello,   I am a beginner with Dax and I am trying to accept two columns ("Date" and "Reported Date") and each columns contains a date formatted date value.   I am looking to create a calculated c...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hello.

     

    You could simply add new column then type this in the formula bar:

     

    New Column = IF( TableName[Date] = TableName[Reported Date], 1, 0)

    Hope this helps!

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hello.

 

You could simply add new column then type this in the formula bar:

 

New Column = IF( TableName[Date] = TableName[Reported Date], 1, 0)

Hope this helps!

marksappleton's avatar
marksappleton
Frequent Visitor
8 years ago

Thanks for your reply.

 

I did do this but it the dates are in different tables and also when I go to enter one of the dates in the other table, the auto options when typing don't contain that field to select.  I have setup the two tables with a relationship back to a dimdate table.

 

I've tried a lot of things but cannot get it working properly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Oh! You forgot to mention that the dates are from two tables. You need to create a relationship between the two tables. It would be better if you could share your data or maybe a sample of your data in different tables.

    • marksappleton's avatar
      marksappleton
      Frequent Visitor
      7 years ago

      Many thanks for your replies.  I managed to sort it out myself in the end. :-)