Hi All,
I have a large data file where many fields are manually rolled up to a higher category currently using vlookups in excel and manually having to import, clean, and update a powerbi dashboard. Is there a way to get this to happen automatically in powerbi? I have the data set feeding from NextGear Dash software through an API and I need fields automatically created based on logic/vlookups.
For Example:
I have a field called "Division" that autosyncs through my API. I need this field to roll up to a new "business segment" category. In excel, I can use a vlookup to create this new column, but that is outside of my autosyncing feed from Dash.
Division can be any of the following 9 options, but I need them to roll up to only 2 in a new column
| Division: | Business Segment: |
| Consulting | Mitigation |
| Contents | Mitigation |
| Emergency Services | Mitigation |
| Environmental | Mitigation |
| Mitigation | Mitigation |
| Mold | Mitigation |
| New Construction | Restoration |
| Restoration | Restoration |
| Structural Cleaning | Mitigation |
