Forum Discussion
Shreesefwere
Helper IV
Helper IVcase condition power bi
Hi Expert,
i wanted to use case condition as follows in SSAS
case when table1.x=1 then winter else table2.b
expected output
3 Replies
- amitchandak
Super User
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
ShreesefwereSir,
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])
