Forum Discussion
calculate datediff column date using filters
hello, I need help using DAX. Her is my problem: I have a table of operation and their date for multiple scenarios with column date and I want to do a datediff on this column using filters: Ex...
I've found the solution , I created a table with :
Table =VAR xxxx =SUMMARIZECOLUMNS('dwh BU'[LB_BU],'dwh OPERATION_SIMULATION'[CD_OPERATION],"datediff_XX", DATEDIFF ( CALCULATE ( FIRSTDATE( 'dwh OPERATION_SIMULATION'[DT_XX] ), 'dwh TYPE_SCENARIO'[LB_TYPE_SCENARIO] = "Premier validé" ),CALCULATE ( FIRSTDATE( 'dwh OPERATION_SIMULATION'[DT_XX] ), 'dwh TYPE_SCENARIO'[LB_TYPE_SCENARIO] = "Référence" ), DAY ) ,"datediff_YY", DATEDIFF ( CALCULATE ( FIRSTDATE( 'dwh OPERATION_SIMULATION'[DT_YY] ), 'dwh TYPE_SCENARIO'[LB_TYPE_SCENARIO] = "Premier validé" ),CALCULATE ( FIRSTDATE( 'dwh OPERATION_SIMULATION'[DT_YY] ), 'dwh TYPE_SCENARIO'[LB_TYPE_SCENARIO] = "Référence" ), DAY ))return xxxx
Mahesh0016
Super User
Super UserAnonymous ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Sample data :
| ID_OPERATION | ID_TYPE_SCENARIO | DATE_XX | DATE_YY |
| 1 | 1 | 01/01/2023 | 02/01/2023 |
| 1 | 2 | 02/01/2023 | 02/01/2023 |
| 1 | 3 | 10/01/2023 | 11/01/2023 |
| 2 | 1 | 11/01/2023 | 21/01/2023 |
| 2 | 2 | 12/07/2023 | 12/03/2023 |
| 2 | 3 | 13/01/2023 | 13/07/2023 |
output format is a table or Matrix with the folowing column :
| ID_OPERATION | diff_date_XX | Diff_DATE_YY |
| 1 | 1 | 0 |
| 2 | 182 | 50 |