Creating a column in report based on live connection with dataset

[Anonymous]

Hi All,

I am trying to create a column in report which is based on previously built dataset but it doesnt give me create a new column.

The scenario is below 

I wanted create a conditional column like 

if Vendor Primary = Vendor Account No then 1 else 0 and then base don that i will highlight the row with some background color.

Create column option is not available when I right click on table

Ideas appreciated....

[vicky_]

Is it possible that you're on direct query mode? You can't create new columns in a table on direct query. 
But if you still want to do conditional formatting, you don't need to create a calculated column, just create a measure and format based on that.

[Anonymous]

Yes i am on DQ mode, also how would we create measure comparing two column values?

[Anonymous]

Hi @Anonymous 

You can refer to the following measure

Measure =
IF (
    SELECTEDVALUE ( 'Table'[Vendor Primary] )
        = SELECTEDVALUE ( 'Table'[Vendor Account] ),
    1,
    0
)

Then put the field to the conditional formatting

Best Regards!

Yolo Zhu

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

[Anonymous]

@v-xinruzhu-msft i tried the same andmoment i add the measure in report it shows me many records as below