Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

True or False Conditional formatting inside the same tables and DAX

Hi,   How can I compare the multiple column inside the same tables via Power BI formula and conditional formating?   I have a one Table that contains text and numbers from column B:I.  Column B:...
  • BA_Pete's avatar
    BA_Pete
    6 years ago

    Hi Anonymous ,

     

    Please try this calculation in your custom column:

    if List.IsEmpty(List.RemoveMatchingItems(Record.FieldValues(_), {"", null})) then "NA"
else if [FRUIT LIST] = [FRUIT LIST_1] and
[AREA CODE] = [AREA CODE_2] and
[LANGUAGE] = [LANGUAGE_3] and
[SALES CODE] = [SALES CODE_4]
then "YES" else "NO"

     

    Pete 

BA_Pete's avatar
BA_Pete
Super User
6 years ago

Hi Anonymous ,

 

When you say "Power BI formula", do you mean Power Query M code? If so, have you imported these tables into Power Query and what do they look like if you have?

 

Pete

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    thanks for your reply. Yes tge data are uploaded in power Bi. 

     

    The power BI formula : I mean by creating measure.

    what mean by Power query M code? Sorry I am new to power BI. Please explain. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      If possible to achieve my output through the conditional formatting (add column - - - conditional formatting)? Please advice. 

      • BA_Pete's avatar
        BA_Pete
        Super User
        6 years ago

        Anonymous 

         

        Power Query M language is what you use to make transformations to your data, within Power Query in Power BI Desktop, before you send it to the data model.

         

        When you say "Uploaded to Power BI" do you mean you have uploaded your excel file exactly as your screenshot shows as a dataset on the Power BI webpage, or you have imported the Excel file into Power BI Desktop?

         

        And when you ask about conditional formatting, based on your required outcome, I believe you mean a conditional column. This can be done quite easily in a number of ways, but I need to understand whereabouts in Power BI your data is and what format it is in so that I can give you the right solution, hence all the questions. 

         

        Pete