Hi,
I am trying to display number of days between two dates :
I have two date columns(Joining_Date, Resigned_Date) in EMPtable and have created Independent Dimdate table and created slicer for Dimdate .
Now i want to get datediff between [Joining_Date] and Dimdate from 'date slicer' having condition on Resigned_Date.
Below is the table Having Columns empid, joing_date, Resigned_date,
here Dimdate[date] is the selected date from filter.
I want to create measure DateDifference to calculate number of days between 'joining date' and 'dimdate' for empids whose 'Resigned_Date is greater than Dimdate or Resigned not present'.
| EMPIID | Joining_Date | Resigned_Date | Dimdate (selected date from slicer) | DateDifference |
| 1234 | 02-09-2020 | 08-06-2021 | 20-02-2023 | |
| 3214 | 25-02-2021 | 31-03-2021 | 21-02-2023 | |
| 1231 | 04-03-2021 | 31-03-2021 | 22-02-2023 | |
| 5334 | 27-03-2021 | 17-04-2021 | 23-02-2023 | |
| 4464 | 06-04-2021 | | 24-02-2023 | 685 |
| 1112 | 06-04-2021 | | 25-02-2023 | 685 |
| 7456 | 06-04-2021 | | 26-02-2023 | 685 |
can someone please help me to get this done
