User Profile
Kumarun
Helper I
Joined 4 years ago
User Widgets
Contributions
Re: lookup values
EMPLOYEE INFO PA0001 TABLE VISA_ID START DATE END DATE 157 06-12-22 31-12-22 157 01-01-23 31-12-99 158 01-12-2021 31-12-2022 Here single employee has two records and different start date and end date so i need start date and end date column from this table to emp visa request table so by using the below formula formula: = CALCULATE( FIRSTNONBLANK( Employee_info_pa0001[start_date],1), FILTER( ALL(Employee_info_pa0001),Employee_info_pa0001[emp_id]=Emp_Visa_Request[visa_requester_id])) getting the results like below EMP VISA REQUEST TABLE visa_id start date end date 157 06-12-22 31-12-22 157 06-12-22 31-12-22 157 06-12-22 31-12-22 157 06-12-22 31-12-22 158 01-12-2021 31-12-2022 In the main table single employee has one record or morethan one record but here it is picking the first entry date only not all the date. so i need all the dates how can i get it? output VISA_ID START DATE END DATE 157 06-12-22 31-12-22 157 01-01-23 31-12-99 157 157 158 01-12-2021 31-12-2022 in the output need all the dates from main table but the issue is i have only employee column for maping there is no other column to getting different dates.lookup values
Hi, folks, I have two tables Table1 and Table 2 I need the start_date and end date from Table 2 so here I just mapped with emp_id = emp_id, so I'm getting the results like this. it's taking first-entry records only because I'm using the first nonblank function. NOTE: Emp_id column is only possible for mapping I need the output like belowNeed All the data in table
Hai Team, Filed record Approved records Table I have two dates one is the Application filed date, and the Application approved date. November month filed records are 6 and approved records are 8. So, by using the date table I have selected November month its showing the correct records in the matrix visual. I am getting only 6 records in tabular visual it is taking only filed data, not the approved data. I need to be filed and approved records combined in single tabular visual means 6+8=14. Help me Thanks in Advance
