Forum Discussion

PBIDEV_10's avatar
PBIDEV_10
Helper II
4 years ago
Solved

Denormalized table for project data

Hello Gurus I have an excel file as an input with project data. The data shows how many departments have worked on the project. The raw data looks like this:  Project name Project description ...
Need Help
Show and Tell
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    Hi PBIDEV_10 ,

     

    Select your [Department] column and go to Transform tab > Split Column (Dropdown) > By Delimiter.

    In the first dropdown in the dialog, choose Custom and enter '; ' (semicolon space) without the apostrophes.

    Leave it to split at each occurrence of the delimiter.

    Under Advanced Options, choose to split into rows.

    I would, at this point add a conditional column or merge that gets the [Department_PK] from your dimension table, then use this in a Snowflake model to be able to control by Division as well.

     

    Pete

BA_Pete's avatar
BA_Pete
Super User
4 years ago

Hi PBIDEV_10 ,

 

Select your [Department] column and go to Transform tab > Split Column (Dropdown) > By Delimiter.

In the first dropdown in the dialog, choose Custom and enter '; ' (semicolon space) without the apostrophes.

Leave it to split at each occurrence of the delimiter.

Under Advanced Options, choose to split into rows.

I would, at this point add a conditional column or merge that gets the [Department_PK] from your dimension table, then use this in a Snowflake model to be able to control by Division as well.

 

Pete