Forum Discussion
Creating a clustered chart using two date values
Anonymous , You can join both dates with a common date dimension. One join will be inactive. You can use userelation to activate join.
refer to this blog how to deal with blog - https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
Thank you for the suggestion. Unfortunatly this had no effect on my values. Somehow I don't think they are connecting properly.
- can you share your relationship view and the fields the joining on?
Table is my date table, Query 1 is the set of dates that I want to alter. Metrology Request is my main table. I want to show created per month and completed from that month based on the values in metrology request. I want to show completed by month based on the data in Query 1. I have a graph currently functioning for created by month and completed from that month. that is using the date in the date table as an axis. Unfortunatly when I add in the completed data from Query 1, the numbers are not what they should be.
