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.
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.
Solved! Go to 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.
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
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.
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 |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |