Forum Discussion
Solved
Aggregate Patient Claims when Exceeding Threshold
Hi PBI Gurus! Need some help. Here's my dilemma: Part 1 - Table Here is my data table example Special ID reporting_date $ Medical Spend ABC123 1/1/2021 ...
Hi novotnajk
Here is my .pbix https://1drv.ms/u/s!AgCd7AyfqZtE3zw8aPY2ndPJl7a4?e=mmShevI believe that this solves both questions,
Thank you,
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
NathanielHi Nathaniel!
We fixed all but one of the problems! 🙂 I'm going to repost the outstanding issue. Thanks for your help!
Hi Nathaniel,
Step 1: Removing CALCULATE from the $ Medical Spend was done.
It now reads:
$ Medical Spend = (SUM(Medical[cost])
Step 2 for Cumulative Medical, the formula is this:
$ Cumulative Medical Spend =
var _currentDate = MAX('Reporting'[reporting_date])
var _calc = CALCULATE([$ Medical Spend],FILTER(ALL('Reporting'[reporting_date]),'Reporting'[reporting_date] <=_currentDate))
return _calc
This did not work. See screenshot.