Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
king98027
Frequent Visitor

Calculating total per quarter for specified age

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_1-1704908394569.png



 






4 REPLIES 4
Greg_Deckler
Community Champion
Community Champion

@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)

??



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

@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? 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

@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. 

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors