Calculate Age By Months

[Anonymous]

Hi,

I am working on Power BI, I have Computers table with ManufacturingDate. I have DimDate table as well. Currently no relationship is created between them. I want to calculate Age of computer by Month. E.G.

If I select Date from DimDate table and Age from Computers table it should give me age of computers by month.

[v-piga-msft]

Hi @Anonymous,

Have you solved your problem?

If you have solved, could you please share your solution or always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please share your data sample which could reproduce the scenario and your desired output so that we could help further?

Best  Regards,

Cherry

[Greg_Deckler · Accepted solution]

Sample data would help. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

That being said, you should just have to create a VAR that gives you MAX('DimDate'[Date]) and then subtract this from [ManufactureDate]

Tough to say without example data and expected output from said sample data.