Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I'm trying to understand the easiest way to calculate the total # of assets with a specified age at the end of each quarter.
Particularly, I want to know:
count of assets that are 365 days old or less at the end of each quarter
count of assets are 366 days to 2555 days at the end of each quarter
The asset age is defined by the 'Created On Date' and is in day format. The report will be filtering the 'Year/Qtr', typically showing the 4 most recent quarters.
Here is an example table:
@king98027 So maybe something like:
Assets 365 =
VAR __Table = FILTER(ALLSELECTED('Table'), [Asset's Age] <= 365)
VAR __Result = COUNTROWS(__Table)
Assets 365 to 2555
VAR __Table = FILTER(ALLSELECTED('Table'), [Asset's Age] > 365 && <= 2555)
VAR __Result = COUNTROWS(__Table)
??
@Greg_Deckler Thanks for the reply! I tried using the first measure - looks like this was basically counting up the total number of assets that are currently 365 days old or less. What I was hoping for, with a quarter/year filter was to understand how many assets meet this criteria at each given quarter from the past.
Here is the exact measure that was created:
Assets 365 =
VAR __Table = FILTER(ALLSELECTED('Customer Assets'), [Asset's Age] <= 365)
VAR __Result = COUNTROWS(__Table)
RETURN
__Result
@king98027 So your Asset's Age column denotes the current age as of, for example "today", is that correct? If that is the case, then you could use the end of the quarter date and the asset's created on date to do a calculation of the asset age at the end of the quarter. Are your quarters calendar based or fiscal?
@Greg_Deckler That is correct. The asset age would be based off today's date. Quarters are calendar based. Unclear about how to go forth.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!