Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a data set of CPT Procedure codes and I am looking to get the sum of their units but I want to exclude codes that contain 0503 after July 1, 2023.
I tried using a cobination of dax formulas and I tried this formula but I dont think I used it correctly.
Solved! Go to Solution.
Hi @ljcrwfr1
If you could provide sample data that would be more handy for solving the problem. Here is my solution
you can try this measure:
CALCULATE( SUM('Appended Raw Data'[chg units sum]), FILTER( 'Appended Raw Data', LEFT('Appended Raw Data'[proccode], 4) <> "0503" || 'Calendar'[Date] <= DATE(2023, 7, 1) ) )
this should work
Did I answer your question? if not please more details about data and problem statment
Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: https://www.youtube.com/@letssolveproblem
Regards
Hi @ljcrwfr1
If you could provide sample data that would be more handy for solving the problem. Here is my solution
you can try this measure:
CALCULATE( SUM('Appended Raw Data'[chg units sum]), FILTER( 'Appended Raw Data', LEFT('Appended Raw Data'[proccode], 4) <> "0503" || 'Calendar'[Date] <= DATE(2023, 7, 1) ) )
this should work
Did I answer your question? if not please more details about data and problem statment
Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: https://www.youtube.com/@letssolveproblem
Regards
This worked! Thanks a million
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
87 | |
87 | |
52 | |
37 | |
23 |