Forum Discussion
Measures
Hello, Im having trouble creating a mesaure from two differenet tables. I need Ridership/ Act in Serv Hours. I need it by year and month. For example August 2022 for Circulator = 63286/684...
Additionally when I go to the original matrix and click on the month and service, it will show me what I need. How can I get it to stay that way?
amandabus21 ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
If both tables are joined with a common date table then your measure Divide(Sum(Table1[Val]), Sum(Table2[Val])) should work
