Creation of a specific table

[Anonymous]

Hello everyone,

I would like to find some help on this post.

Indeed, I have to create this following table (extract from excel) on Power BI:

In my company, employees record their hours worked on business numbers (this allows for an analytical analysis later on).
This table is used to see which hours are "unproductive or productive".

To assign the hours to each section, they must look at the business number (N°Affaire) for example:
-The hours pointed on business numbers (N°Affaire) beginning with N* are associated with the section "Projets Neufs" (as you can see on the screen on the left of the section names we have the characteristic linked to the business number (N°Affaire).

Here is my database on Power BI :

Basically I was thinking of doing something like this: IF(N°Affaire starts with N* then "Projets Neufs") But I don't see how to do it in Power BI since I am a beginner.
I don't know if I should create a new column, or set up a new data table with the name of the sections and their characteristics (N*, etc...)

I am also afraid that there is a conflict between 2 arguments because :
-the "Essais" section receives the hours clocked on N°Affaire starting with D*.
-the "Développement Interne" section receives the hours clocked in on a N°Affaire starting with DI*.
I'm afraid that the "Essais" section also receives the hours clocked on case number starting with DI* whereas it is necessary that those which start with D* and not with DI*

Could you help me? If you need more details or particular needs do not hesitate.

Sincerely, VALLERANT Maxime

[Anonymous]

Hi @Anonymous ,

It looks like creating a matrix, and the column names of your dataset are not in English. Sorry not to understand your language. Can you provide me with some dummy data in English and pr

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

esent the expected results.

[Anonymous]

Hi @Anonymous, 

I have found the solution by myself, thank you for your time.