Forum Discussion

Frequent Visitor

9 years ago

Solved

DAX

How to write the formula in DAX Sum(Case When (columnname) < 10 Then 1 Else 0 End) Over (Partition By ColumnName)

Anonymous

9 years ago

You can refer to below formual about the if statement:

1. Dax.

Calculate column:

Result =IF([columnname]<10,1,0)

2. Power Query.

 if [columnname]<10 then 1 else 0

Full query:
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each if [ID] <10 then 1 else 0)

Regards,

Xiaoxin Sheng

Anonymous

Not applicable

9 years ago

You can refer to below formual about the if statement:

1. Dax.

Calculate column:

Result =IF([columnname]<10,1,0)

2. Power Query.

 if [columnname]<10 then 1 else 0

Full query:
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each if [ID] <10 then 1 else 0)

Regards,

Xiaoxin Sheng