Forum Discussion

ashraf_K's avatar
ashraf_K
Frequent Visitor
4 years ago
Solved

Count aging dynamically and place in bucket

Hello, I am trying to calculate the aging for customers based on a date slicer, put the ages in buckets and count the number of customers. I already calculated the age from the DOB dynamically.   ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    You may refer to my solution in this PBI file.

    Hope this helps.

JB_AT's avatar
JB_AT
Icon for Helper III rankHelper III
2 years ago

Ashish_Mathur The file doesn't exit anymore, can you provide the steps you took to get the result?

Thanks

ashraf_K's avatar
ashraf_K
Frequent Visitor
2 years ago

Hello JB_AT,

 

You can access the file from this link.


  • JB_AT's avatar
    JB_AT
    Icon for Helper III rankHelper III
    2 years ago

    Thank you!

  • JB_AT's avatar
    JB_AT
    Icon for Helper III rankHelper III
    2 years ago

    Your file is exactly what I am trying to achieve, but is it possible to achieve the same result using measures? I have opened a post here explaining my issue

     https://community.fabric.microsoft.com/t5/Desktop/Dynamic-Buckets/m-p/3521814 

    I have a history table with multiple rows for an ID, that's why I am using Running Totals. I basically want to capture the Years of Service for the Date Range I choose in my slicer

     

    Thank you