Calculate age from dob field and another date value using slicer

0 votes
How to calculate age from dob field and using slicer to choose current year?
5 days ago in Power BI by Karthick
9 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes
Hi Karthick,

Create a parameter with year range as per data requirement.(ex: 2010-2018 and provide increment as 1)

Create a column as DATEDIFF([DOB],[Parameter-name],YEAR).

The above field would fetch the age or years.

Hope it helps.
answered 5 days ago by anonymous
• 13,860 points

Related Questions In Power BI

0 votes
1 answer

Bar chart : Arranging in descending order using data from another chart

Select treemap.  Make it active.  Turn on Visual Interactions ...READ MORE

answered Feb 7 in Power BI by Upasana
• 7,560 points
13 views
0 votes
1 answer

Can i show data for one variable for a field without using slicer?

Hi Pranav, Yes, you can perform the calculation ...READ MORE

answered 6 days ago in Power BI by CHERUKURI
• 13,860 points
6 views
0 votes
1 answer
0 votes
1 answer

How to export Power Queries from One Workbook to Another with VBA?

Try solving it using the Workbook. Query ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,190 points
128 views
0 votes
1 answer

Displaying Table Schema using Power BI with Azure IoT Hub

Answering your first question, Event Hubs are ...READ MORE

answered Aug 1, 2018 in IoT (Internet of Things) by nirvana
• 3,040 points
48 views
0 votes
1 answer

Unable to install connector for Power Bi and PostgreSQL

I think the problem is not at ...READ MORE

answered Aug 21, 2018 in Power BI by nirvana
• 3,040 points
346 views
+2 votes
2 answers

Migrate power bi collection to power bi embedded

I agree with Kalgi, this method is ...READ MORE

answered Oct 11, 2018 in Power BI by Hannah
• 14,080 points
57 views
0 votes
1 answer

Connect power bi desktop to dataset and create custom reports

Yes using Power BI REST API to ...READ MORE

answered Sep 18, 2018 in Power BI by Kalgi
• 35,750 points
49 views
0 votes
1 answer

Measure to filter date from another field

Hi, Create a column with [date-field].[month] to fetch ...READ MORE

answered 5 days ago in Power BI by CHERUKURI
• 13,860 points
7 views
0 votes
1 answer

Multiple slicer using same field

Hi Anitha, You can use the same filed ...READ MORE

answered May 8 in Power BI by CHERUKURI
• 13,860 points
9 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.