Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi!
New day, new challenge;) @v-kelly-msft
My goal:
When i change the date slicer to a specific date, i need the data to show the amount outstanding, on that point, historical. I got that to work with these 3 measures;
1. selected date = MAXX(KEEPFILTERS(VALUES('Calendar'[Date])),CALCULATE(MAX('Calendar'[Date])))
Solved! Go to Solution.
Hi!
I found the solution I needed in this video --> https://www.youtube.com/watch?v=5_KDJGPjMnI
Thanks for al the help!
hi @RH-BIP
This is a common Dynamic Segmentation problem, you could refer to these three blogs to get it:
https://www.daxpatterns.com/dynamic-segmentation/
https://powerbi.tips/2016/04/power-bi-histogram-with-bins/
https://powerpivotpro.com/2015/03/creating-a-histogram-with-a-user-defined-number-of-buckets/
Regards,
Lin
Hi!
I found the solution I needed in this video --> https://www.youtube.com/watch?v=5_KDJGPjMnI
Thanks for al the help!
hi @RH-BIP
you cannot create calculated column for this requirement. Measures will show only the summarized data unless we add rows to the table visual like (invoice date, due time, etc). I suggest you to create measures seperately for due< 30 days , due 90 -180, due 180-365, due >365. Then you can visualize like below
for ex:
due time due<30 due 90-180 due 180-365 due >365
total amount
(on selected date) 351 256 1246 27
Hi! tried that also, but the amount is the same in every column. Because the aging days is zero, only when I add InvoiceDate the table expands and shows the correct aging days per row. Maybe you know why?
use DateDiff function to calculate difference of days between the minimum date and the selected date on slicer.
Thanks for helping, its driving me crazy for a while now 😉
I tried your approach, but does not work (yet). < 30 and Due < 30 days dont show anything, but as you can see there are plenty invoices within 30 days.
*drag Due < 30 days, Due 30 to 365 days, Due > 365 days these meausres as columns to the table visual.* <-- I cant drag the measures as in the column field within a matrix. I only get these measures into a table.
Hope you can help!
create a seperate date table
@RH-BIP , did not get it completely. see if bining can help
https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization
Unfortunately you cannot create Dynamic Column Value because Computed Column is pre-calculated. You would require a Measure to make it dynamic
Proud to be a Super User!
Yes, i know. I already made a measure, and it shows the correct data..but only in a table with the field (dimension) Invoice_date. When I remove Invoice_date all rows collapse to 1 row, also the aging groups.
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |