Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello All
Is there is a possibility to get sample PBIX file for "Dynamically Group Receivables Based On When Cash Is Expected"?
I have seen this is YouTube but couldn't find any PBIX sample file.
Any help would be much appreciated.
Solved! Go to Solution.
This is a common problem, here are two simple sample for you refer to:
https://powerbi.tips/2016/04/power-bi-histogram-with-bins/
and
https://powerpivotpro.com/2015/03/creating-a-histogram-with-a-user-defined-number-of-buckets/
Regards,
Lin
Hi,
Share a dataset and show the expected result.
This is a common problem, here are two simple sample for you refer to:
https://powerbi.tips/2016/04/power-bi-histogram-with-bins/
and
https://powerpivotpro.com/2015/03/creating-a-histogram-with-a-user-defined-number-of-buckets/
Regards,
Lin
@gauravnarchal , I think you are looking for binning or dynamic segmentation.
The idea is to create a measure like Age. Then with an independent bucket table and use this measure and create a measure taking care of the row context. So that it becomes part of the bucket
https://www.daxpatterns.com/dynamic-segmentation/
https://www.daxpatterns.com/static-segmentation/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-po...
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization
https://radacad.com/dynamic-banding-or-grouping-in-power-bi-using-dax-measures-choose-the-size-of-bi...
https://www.credera.com/blog/technology-solutions/creating-aging-report-using-a-user-selected-date-i...
@gauravnarchal - I believe Enterprise DNA has a website where you can pay for courses. https://enterprisedna.co/
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |