Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to extract age from DOB of a sample data.
The initial field is DOB with data type Date time and value is 1900-01-01 12:00:00 AM for every field.
I changed it to the date type Date in transform. As i am trying to get Age from the Date tab, it is giving me value as 0. Can someone please suggest why is it so?
Solved! Go to Solution.
Hi,
Use the DATEDIFF() function as a calculated column formula. The second input should be TODAY().
Hi @Meghbajaj,
Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Hi,
Use the DATEDIFF() function as a calculated column formula. The second input should be TODAY().
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |