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...
  • 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