Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Team,
I have condition to categorize the aging of Invoice
and the formula of aging is number of days start from DueDate to ReportingDate that selected by user as picture, the issue is the value always return Max Reporting Date in the calendar table (31/12/2021).
Any insight and assistance would be greatly appreciated. Thank you
Regards,
Agus
I am working on a similar issue. I created a table called Selected Dates. We are only looking back at the past 60 days.
Hi , @Anonymous
Can you show me the relationship between your calendar table and fact table?
In addition, please pay attention to the data type and summarization of your field "ReportDate".
Best Regards,
Community Support Team _ Eason
Thanks for you response and attached the table relations and you can download my pbix file https://1drv.ms/u/s!Aih1MRphMRei21KYxISSSRNhWlK9?e=3wtTzH
@RondaHill I had try with column but therresult of date always today but if I tried with measure the date result is latest of selected date but the issue in chart only shown I bar chart as picture how the differents
HI All,
I still did not get solution, any help appreciated.
Thanks & Regards,
Hi , @Anonymous
Sorry for late reply.
It seems that you just need to drag the measure "m_report date" to "values",then you will get what you want ...
Best Regards,
Community Support Team _ Eason
I am agreed with you putting m_report date" to "values" will be display correctly in table but still incorrect for aging calculation
Regards,
supriatna
Hi , @Anonymous
Once the calculated column is created, its results in the table will not be affected no matter how you change the slicer value .
So all new data fields that need to be affected by the slicer should be created with measure rather than calculated column.
In fact, I think you already got the results you want. The two correct visual on the upper left and lower right that you have kept is exactly what you want.
If I misunderstand,please feel free to let me know.
Best Regards,
Community Support Team _ Eason
Many thanks for your response
For my condition m Aging calculated measures is the correct one (in red colour) since the aging calculated base on the latest selected date, you can see the different result between c Aging (today) and m Aging (lates selected date).
The problem is when m Aging Cat put in Bar Chart only shows one bar (>120 ). I don't know why the field m Aging Cat can't put in the axis of the bar chart.
Regards,
Supriatna
@Anonymous , I think this case of Dynamic segmentation or binning
https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization
@amitchandak thank you for your respon
Segmentation or binning could be used after the aging value is correct, the problem is not grouping but how to get aging value based on last date of selected reporting date
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |