I’m working with datasets that lack critical information for AR trend analysis. I can age the insurance AR open amount but there’s no field within the raw table but when updating the raw data pull I lose the data from the previous load as there’s no as of date within the file.
It seems like there should be a way for me to take the measure result totals by group totals and populate a table appending a date to the information
For example from this snip I’d want to have the trending ar table show
0-30 978.55 date stamped 4/30/2021
31-60 748.36 also date date stamped 4/30/2021
So that at end of May I can compare the totals in the aging group buckets.
Hopefully this makes sense and I’m posting in the right forum topic thinking all this work is done in the query editor.
PBIX attached - I’m working in a healthcare environment so this pbix has identifiable data removed and is where I test out formulas before I bring into real data. Tab in question is call A/R
Thanks in advance
Hi @gkavesh , we aim to consistently improve the topics being posted on the forum to help you in getting a strong solution faster. While waiting for a response, here are some tips so you can get the most out of the forum and other Enterprise DNA resources.
-
Include the masked demo pbix file (You mentioned that the PBIX is attached but there is nothing attached in the post.)
-
Images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details.
I also suggest that you check the forum guideline How To Use The Enterprise DNA Support Forum. Not adhering to it may sometimes cause delay in getting an answer.
Please also check the How To Mask Sensitive Data thread for some tips on how to mask your pbix file.
Guess the PBIX didn’t attach -
Here it is - Tab where data is in ‘aging test’.FrequencySample.pbix (626.1 KB)
Hi @gkavesh ! We noticed that your inquiry was left unsolved for quite some time now. We strive to answer ALL inquiries in the forum. However, if you are sure that you provided all pertinent context to your concerns and read how to use the forum more effectively and still find your question unanswered, you can check out tutorials to learn this yourself as your membership also comes with relevant resources that may help you with your Power BI education.
While our users and experts do as much as reasonable to help you with your inquiries, not all concerns can be attended to promptly especially if there are some learnings to be done.
Bumping this post too, for more visibility. Thanks for your patience.
Hi @gkavesh, due to inactivity, we are marking this post as “Solved”.
