The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
56 | |
32 | |
20 | |
17 | |
15 |
User | Count |
---|---|
53 | |
31 | |
30 | |
23 | |
21 |