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.
Hello,
I am actually working on an AR ageing report.
My data model is as follows: I have a AR transaction table with the amount, with a Date filed related to a calendar table.
So far, I have managed to get the ageing as at today. I have added a calculated column, to calculate the age of the transaction and have used this measure to make it work:
Hi Akhtar.
i think it's not possible to have a dynamic column that respond to a slicer.
but if you want to have calculated column.
then you can create a crossjoin calculated table that consist a calendar and age group.
something like this formula:
Summary AR =
var tblCalendar = SELECTCOLUMNS('Calendar', "Date", 'Calendar'[Date])
var tblAgeingGroup = SELECTCOLUMNS('Ageing Group', "Age Group", 'Ageing Group'[Age Group])
var tblClient = SELECTCOLUMNS(Client, "DCLink", Client[DCLink])
return CROSSJOIN(tblCalendar,tblAgeingGroup,tblClient)
then you can add calculated column for each reporting date, age group and client either to count number of transactions and amount.
finally, create a relationship between your calendar table with new summary AR table.
-
Can you provide sample data or a mock-up PBIX file?
Proud to be a Super User!
Paul on Linkedin.
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |