Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

power bi report help please

Hi I am trying to make equipments availability report for certain date from 2 tables linked together by specific date say for example (03/03/2019) that date return to the jobs that we did in some...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous ,

     

    You can consider extract date value to create a bridge table to link two tables, then you can choose single direction relationship to let it keep all records.

    HOW TO JOIN MANY TO MANY WITH A BRIDGE TABLE IN POWER BI

     

    Regards,

    Xioaxin Sheng

  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous ,

    Have you consider to break relationships and write a measure to achieve filter effect?

    Applying a measure filter in Power BI

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous ,

 

You can consider extract date value to create a bridge table to link two tables, then you can choose single direction relationship to let it keep all records.

HOW TO JOIN MANY TO MANY WITH A BRIDGE TABLE IN POWER BI

 

Regards,

Xioaxin Sheng

Anonymous's avatar
Anonymous
Not applicable
7 years ago

thanks for your response

but the dates are in only one table the (job_code) is the relation between the tables if i want to extract a column to be a bridge

is the job_code.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous ,

    Have you consider to break relationships and write a measure to achieve filter effect?

    Applying a measure filter in Power BI

    Regards,

    Xiaoxin Sheng