Forum Discussion

kaye123's avatar
kaye123
Frequent Visitor
3 years ago
Solved

PowerQuery If Statement with Result from Measure of another table

I created a custom table that have 4 different Names. Then I will add a column with a Measure from different tables but with conditional if statement.  See target condition below.   Column1 If Tex...
Need Help
  • kaye123's avatar
    kaye123
    3 years ago

    This is now ok. I used a SWITCH code instead of IF statement. Worked like a charm.

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
3 years ago

It looks like you are trying to use measures (created for visuals in powerbi report view) in Power Query.  That's definitely not possible.

Maybe if you give more details about what you are trying to achieve I can offer some advice.