Creating Column

[AlanP514]

Hai Guys I am New to DAX Please help me 

I have a table certification logs and I have column named certifications it has different values 1 star. 2 star, 3 stars,
I want to create a calculated column only with 1-star certifications
At the power query level, we can do it, but I am searching DAX level

[Anonymous · Accepted solution]

Hi  @AlanP514 ,

I created some data:

Here are the steps you can follow：

Create calculated column.

New Column =
IF(
    'Table'[certifications]="1 star",'Table'[certifications],BLANK())

Or you can create a calculated table:

Table 3 =
FILTER(ALL('Table_Copy'),'Table_Copy'[certifications]="1 star")

Best Regards,

Liu Yang

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

[AlanP514]

Thank you for your solution , This will work

[amitchandak]

@AlanP514 , A new column like

if([certifications] ="1 star", True(), false())

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.