Forum Discussion
Dynamic table comparison
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
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
Hi! Thank you for getting back to me. Will this still work if Tabl 1 has no user ID?
Yes Table1 Has UserID it works, if you look at the PBIX file which i shared has a solution. Thanks
I am trying to replicate your solution with my tables. However, my access Table doesn't have user ID.
