CODEWITHSUNDEEP
powerbi
user14104064
user14104064

Reputation:

Power BI measure to fill table rows

I was wondering if its possible to create a measure in Power BI to fill rows with a certain word like "Yes" if another row is not blank.

The table should look something like this:

Item - Sold Number - Was anything sold

Bike - 100 - Yes

Car - 50- Yes

Truck - (blank) - (blank)

Upvotes: 0

Views: 226

Answers (1)

PowerStar
PowerStar

Reputation: 895

You can create a new column(Flag) with the following:

Flag = IF(ISBLANK(your_table_name[Sold Number]),"Blank","Yes")

Upvotes: 1

Related Questions