Combine 2 column into single value

[Anonymous]

Hi,

I need help to create visual in power bi like this (Expected Results)

And I already created but the result shows (UnExpected Results)

The question is how 1 value in Resource Name can have 2 values (value of true and value of false) at once ?

Any kind of answer, will help and appreciated.

Regards,

diar

[Anonymous]

There are quite a few ways to achieve this and what you want to do entirely depends on the larger use-case for your data.

The simpliest solution is to 'unpivot' the data.  This will mean that you will have 2 identifying columns, the name of item "nama" and the type "True or False"

From here, you can create measures that sum the value column based on the type filter.

Your question now is going to be: "How do i unpivot the data?"
This really quite easy, go into Transform Data (Power Query).  Find the table (Query) that contains your data.  Use the button on the "Transform" tab of the ribbon called "Unpivot Data".  Its about a third of the way along.

[amitchandak · Accepted solution]

Take max of first or last of status. If it needs to be date based then it needs to be calculated.

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

[Anonymous]

Thanks for the answer,

I use the "Last" of Status