Forum Discussion
Seperate then Calculate Numeric Values in an Alpha Numeric Column
Resolved
Super UserI've stared at your table for a good ten minutes and still cannot understand the structure. Power BI works best with a traditional table structure with rows and columns. Somehow you will need to unpivot your original format.
Maybe you can explain it again? Where does NB-FAM come from?
Hi, and thank you! the NB-FAM is a CPT Code that represents Non Billable Family Services. We use this code when a grant is paying for the service oppossed to an insurance plan.
Here is a pic of the MERGE_Observations table filtered for the data I want
This is what it looks like with no filters in place, You can see the NAME, DESCRIPTION, OBSValue and CPT code columns hold lots of unnecessary information for this report
Hope this helps
Ashley
- lbendlin
Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services. Please show the expected outcome.