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