case condition power bi

[Shreesefwere]

Hi Expert,

 i wanted to use case condition as follows in SSAS

case when table1.x=1 then winter else table2.b

expected output

[Shreesefwere]

Sir,

it is requires in SSAS

[amitchandak]

@Shreesefwere , I think you can merge the table in SSAS and then use a similar formula in DAX

if ([a.x] = 1, [a.y] , [b.b])

[amitchandak]

@Shreesefwere , Use merge in power query using column a and X

and then create a new column in power query

if [a.x] = 1, then [a.y] else [b.b]

Merge Tables (Power Query) : https://youtu.be/zNrmbagO0Oo