Forum Discussion
Conditional
Hi afrutos ,
You can create a calculated column as below, please find the details in the attachment.
Category = VAR _category = CONCATENATEX ( FILTER ( ALL ( 'Authors' ), 'Authors'[IdAuthor] = EARLIER ( 'Authors'[IdAuthor] ) ), [CategoryAuthor], ",", 'Authors'[CategoryAuthor] ) RETURN IF ( _category = "Director,Screenwriter,Writer ", "Director and Screenwriter", 'Authors'[CategoryAuthor] )Best Regards
Hi afrutos ,
You can create a calculated column as below, please find the details in the attachment.
Category =
VAR _category =
CONCATENATEX (
FILTER (
ALL ( 'Authors' ),
'Authors'[IdAuthor] = EARLIER ( 'Authors'[IdAuthor] )
),
[CategoryAuthor],
",",
'Authors'[CategoryAuthor]
)
RETURN
IF (
_category = "Director,Screenwriter,Writer ",
"Director and Screenwriter",
'Authors'[CategoryAuthor]
)
Best Regards
Hi, thank you how did you create the colum "column"?
I need to do this step beforeHi afrutos ,
Please right-click or select the ellipsis ... next to the table Author in the Fields pane, and select New column from the menu just as below screenshot. You can find more details in the following official documentation.
Tutorial: Create calculated columns in Power BI Desktop
Best Regards
Yes I know how to create a new Column, but my question is what did you do in that Calculated Column.
I mean, you showed me the column Category,
Could you please showed me the Column column?
