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 everyone,
I am new to these forums and I am coming across an issue that I have not seen referenced elsewhere, so I thought I would bring it here. Essentially, I have a line chart that shows the performance of different products for certain metrics on a "months since" basis so that they can be compared based on time since inception rather than on linear time. Below is a line chart for default rates, which is a simple formula (default dollars / accounts receivable dollars):
Here is my issue. I have a few metrics where instead of taking AR as my denominator, I am taking average AR over a rolling two month period which is defined by the following measure:
From what I can tell, not only is the default rate incorrect when dividing by average AR, the rate is simply double the amount in the top chart. I'm really unsure of what could be causing this. To give more background on my data model, I have a many-to-one relationship between my fact table and my date table:
My date table looks like this:
And additionally, I have an unconnected "Months Since Start" table which I iterate over with the following measure:
Hi Evelyn. I unfortunately was not able to solve the problem in PowerBI itself due to time constraints. What I ended up doing was to create a smaller table using Pandas, performing a groupby function and then using the .rolling() function to create an actual column for Total Average AR. Not an optimal solution but this was the only way I was able to solve this in the given timeframe. Thank you.
Hi @Anonymous ,
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.
Best Regards,
Eyelyn Qin
Hi @Anonymous ,
It's a little hard to follow.
According to your description, you could use AVERAGEX() or SUMX() or other functions to calculate Measure like: SUMX( FILTER ( TABLE, <CONDITION>), [Measure] )
Please provide me with more details about your table and your problem/expected output or share me with your pbix file from your Onedrive for Business WITHOUT sensitive data.
Best Regards,
Eyelyn Qin
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |