Forum Discussion

ckausihan_12's avatar
ckausihan_12
Helper I
6 years ago
Solved

Dynamic table comparison

Hi, I have two tables, table 1 contains users site access data and table 2 contains a list of all users in the organisation (please see below). I am trying to create a page which will show me a list ...
Need Help
Tutorial Requests
  • VijayP's avatar
    VijayP
    6 years ago

    ckausihan_12 

     

    To Get Time intelligence you need to have date table. With Date Table you can drill down who are Visitors and Non Visitors.

    I am attaching PBIX File here. you can go thru to understand the Table

     

    I have created a Measure showing number of Visitors  SUM(Visitor ID) and then calculated Non Visitors based on total Visits = 0

    I think PBIX File will help  you a lot.  Please Clik on this LINK

    If you find this as Solution please mark this as Solution and Share your Kudos.

    Also you cant Watch my Power BI and Excel Videos at www.youtube.com/perepavijay

    Regards

    Vijay Perepa

ckausihan_12's avatar
ckausihan_12
Helper I
6 years ago

Hi! Thank you for getting back to me. Will this still work if Tabl 1 has no user ID?

VijayP's avatar
VijayP
Community Champion
6 years ago

ckausihan_12 

Yes Table1 Has UserID it works, if you look at the PBIX file which i shared has a solution. Thanks

  • ckausihan_12's avatar
    ckausihan_12
    Helper I
    6 years ago

    I am trying to replicate your solution with my tables. However, my access Table doesn't have user ID.

    • VijayP's avatar
      VijayP
      Community Champion
      6 years ago

      USER ID will create a better 1 to many relation ship and your solution will be fine. Create index column in your Student Table and then use that index number against each student in Main transaction table. then you can get answer easily