Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Bucket Dynamic Aging created by Measure

Hi community,

hope someone can lead me into the proper direction on this question.

I'm working on a project to display aging of units within a selected timeframe and I would like to dynamically display the aging of them in visuals like a pie-charts or clustered column chart split by total inventory Value or Quantity.

What I have so far working:
Dynamic aging calculation based on the selected slicer timeframe (Reporting Period).
When a user is e.g. selecting the month of November the inventory aging is displayed as of november, or when he/she selects October it's also displayed correctly.
All this is achieved with dynamic measures - there is no helper column or similar.

Now I have created an additional measure based on the age of the item. E.g.: an Item that's at the selected timeframe 7 months old will be calculated by the measure "<12" which is perfect.  Measure "ITM_Aging_Cluster"

My measure for the age classification has multiple values e.g.: "< 12", "12 - 15", "15 - 18", "18 - 24" etc.
Ideally I would love to display this information also grouped based on the quantity or value amount of the items. 
Unfortunatley I can't use a measure as legend within a visualisation but this is exactly what I need and I don't want to use a column as I would loose the opportunity to jump back in any point in time to see the historic aging (I don't/wont have aging tables).

View of the data available


Tips and Tricks

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      HI Amit,

       

      Thank you for the links (I watched your video already couple of times 🙂 ) 

      I was following your guide but unfortunatly my buckets stay empty or they display only 1. 

      Here is my meseaure 

      A_TESTBUCKETS = COUNTX(filter(VALUES('Inventory Transactions_V'[Item No]),[ITM_EQ_Aging] >=MIN('2_tbl_aging_helper'[StartValue]) && [ITM_EQ_Aging] <max('2_tbl_aging_helper'[EndValue])),'Inventory Transactions_V'[Item No])

       

      For full visibility my dynamic aging measure:

      ITM_EQ_Aging = SUMX(Item_V,IF(ISBLANK('Item_V'[Vendor Invoice Date]),
      DATEDIFF(Item_V[Date In],[IT_Item_Aging_Month_Helper],MONTH),
      DATEDIFF('Item_V'[Vendor Invoice Date],[IT_Item_Aging_Month_Helper],MONTH)))
       
      The helper table I created:

       

       

      Unfortunatly my results cannot be displayed or in other words they stay empty:

       

      What do I miss?

       

       

      Thank you in advance & happy new year!