Forum Discussion
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...
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!
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.
Many thanks for your replies. I managed to sort it out myself in the end. :-)