CTHUB - CVP column update

[katerinkus]

Describe the task Add a column called "Class" and "Use Case" instead of "Portfolio". Multiples are allowed for both columns. That means it could be a single value or a list in each cell. They will be separated by commas. Both can also be null.

"Class" can be:

• Road - 3
• Road - 4
• Road - 5
• Road - 6
• Road - 7
• Road - 8
• Road - 8C

If it's a list, it would be Road - 7, Road - 8.

Use Case can be a single item or a list. It can be any value. For instance, Marine or Loader, Fork Lift.

Purpose This columns are necessary to get counts for dashboards.

Acceptance Criteria

• [ ] "Class" accepts only values from the list above. It can be a single value or a list. It can also be missing (empty).
• [ ] "Use Case" accepts any values. It can be a single value or a list. It can also be empty.
• [ ] "Portfolio" column is removed.

Additional context

• All this information will be reflected on Teams in Data_2024 folder, CVP, Data_Tab_Format.

[katerinkus]

Check if Power BI understands arrays in cells