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?
May 17, 2019 in Power BI by Karthick
1,783 views

1 answer to this question.

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 May 17, 2019 by anonymous
• 33,030 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 8, 2019 in Power BI by Upasana
• 8,620 points
802 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 May 16, 2019 in Power BI by Cherukuri
• 33,030 points
657 views
0 votes
1 answer

Custom Slicer with two calendar date pickers and custom periods?

This exact look and feel are not ...READ MORE

answered Nov 12, 2020 in Power BI by Gitika
• 65,890 points
1,186 views
0 votes
1 answer

How is Power BI Report Server different from SQL Server Reporting Services and the Power BI online service

Power BI report server is deployed on-premises ...READ MORE

answered Oct 15, 2018 in Power BI by Hannah
• 18,540 points
1,230 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,130 points
1,266 views
+1 vote
1 answer

Unable to install connector for Power Bi and PostgreSQL

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

answered Aug 22, 2018 in Power BI by nirvana
• 3,130 points
2,698 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
• 18,540 points
1,464 views
+1 vote
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
• 52,350 points
1,620 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 May 17, 2019 in Power BI by Cherukuri
• 33,030 points
524 views
0 votes
1 answer

Multiple slicer using same field

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

answered May 8, 2019 in Power BI by Cherukuri
• 33,030 points
5,310 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP