Forum Discussion
Calculated Column creating an empty slicer
I have data that looks something the table below.
I have added a calculated column on this as follows:
ClientCurrentAge = DATEDIFF(Client[DateOfBirth], Client[Today], YEAR)
However when I put this into a slicer visulisation it just comes up blank. Any advice?
| Client ID | Date of Birth |
| 1234 | 25/01/1998 |
| 3215 | 06/12/2005 |
7 Replies
Can you check if you have changed the Dateofbirth column to Date? I see, it might be existing as Text
yes it's data type is Date
I have used the same DAX of yours. It is working for me.
Check if you have selected any of the data?
It's a part of a large databse and when I remove columns to hide sensitive data it then starts working. I wonder if it;s something to do with my relationships? Unfortunately I can't find a way to give you an example pbix file without sensitive data.
Definitely, it is related to relationships.
Regards
Kumail Raza
even if all the columns used in the measure are from the same table?
