Forum Discussion
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...
Anonymous , You need to use binning or bucketing using an independent table
example
Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k
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!