Forum Discussion

Chandra_maha's avatar
Chandra_maha
Icon for Helper I rankHelper I
3 years ago

Interaction not working with reports

Hi,

 

I have following reports, where is has Start date of employees and End data of Employees. Also, I have created a Calendar table with dates.

I have created a relationship of Start date to Date as Many to one. I wanted to create another realtion End date to Date, but I could not as PowerBI not allowing and getting error

This is the actual Report  -

When I am clicking on positive values (Start date of employees), I am getting employee details in following report. However, when I click on negetive value (Exit data of employee) then I do Start date of employee. Basically, I am not getting correct data.

My undestanding is that, because of the realationship, I have created with Start date - its working for Start date. And, as I can not create a realtionship with End Date, its not working for End date.

Is there a way, we can resolve this and can it start working for Start date and End Date.

 

4 Replies

  • Arul's avatar
    Arul
    Icon for Super User rankSuper User

    Chandra_maha ,

    It can be resolved by creating inactive relationship between End date of Employees Table and date in calendar table and then write a measure for that Exit date of employee.
    Could you share the sample data ?

    Thanks,

    • Chandra_maha's avatar
      Chandra_maha
      Icon for Helper I rankHelper I

      Hello Arul 
      Thank you for response. I have inactive relationship for End Date and Date. Following is the sample data

      Employee NameStart DateEnd Date
      b02-10-2017 
      c28-03-202130-12-2021
      d01-03-2020 
      e31-03-201429-11-2021
      f01-02-2021 
      g17-11-2019 
      h31-03-202025-04-2022
      i04-05-2021 
      j09-02-201428-03-2021
      k17-01-202130-08-2021
      l29-09-2018 
      m02-01-2017 
      n30-04-202108-08-2021
      o 04-07-2022
      p01-07-2014 
      q22-03-2020 
      r21-10-2018 
      s18-04-202130-04-2021
      t15-03-2020 
      u10-03-201929-06-2021
      v03-11-202004-05-2021
      w02-03-202007-02-2022
      x02-06-201916-12-2020
      y15-03-2020 
      z25-02-201417-06-2021
      qw05-04-202001-05-2022
      dsd10-06-201813-05-2021
      fg07-03-2021 
      ert30-06-201425-02-2021
      bgf30-06-201917-10-2021
      hg28-03-202125-04-2022
      ert11-04-202107-08-2022
      df16-03-2021 
      xc21-03-202114-11-2022
      sd16-02-202124-11-2021
      sd31-01-202014-06-2022
      ew17-03-202129-11-2021
      bf28-07-201911-09-2022
      sd01-01-201827-07-2021
      yt15-03-202007-10-2021
      uj18-04-201730-05-2021
      iki31-10-2019 
      we02-06-201908-03-2021
      ht16-02-202030-03-2021
      qw19-01-202124-10-2021
      vb09-06-201929-08-2021
      tg03-12-2017 
      fg20-01-201917-02-2022
      sd31-08-201927-02-2021

       
      Thank you in advance.