Create a tenure column from two different tables using calendar date slicer.
Hi, i've following issue in power bi. Here are the details.
Issue: Capturing the date from a date slicer and using the selected value and use it for tenure. I have two date table. One is calendar date table and another one is Employee_Hire_date.
I have to calculate tenure for each date column. I'm using following sql for this. I want to implement this on power BI but i'm facing issue as these two table are not joined with each other. I want the ans in column respective to each hire date.
Hi, I tried to use this dax but it's giving me wrong count. My employee headcount is a measure hence i used it but its giving me wrong count. I think i've to filter it by employee ids. Could you check it once?