IF difference between startdate and updated date >

[moeconsult]

I have the excel formula working but I need help with the dax version of it,

=IF(F2="",A2,IF(AND((D2-F2)>2,E2="Cancelled"),0,A2))

Sample Data below:

    A           B                          C                      D                         E                   F                                  G

fee	Date	Enddate	Startdate	Status	Updated	ExpectedOutput
£10	17/09/2020 16:00	15/09/2020 00:00	15/09/2020	Attended	06/04/2020	£10.00
£10	17/09/2020 16:00	16/09/2020 18:00	16/09/2020	Cancelled	06/04/2020	£0.00
£10	17/09/2020 16:00	29/06/2020 18:00	29/06/2020	Cancelled	28/06/2020	£10.00
£10	17/09/2020 16:00	17/09/2020 16:00	17/09/2020	Pending		£10.00
£10	17/09/2020 16:00	30/06/2020 16:00	30/06/2020	Pending		£10.00
£10	17/09/2020 16:00	15/09/2020 00:00	15/09/2020	Pending		£10.00
£10	17/09/2020 16:00	16/09/2020 18:00	16/09/2020	Pending		£10.00
£10	17/09/2020 16:00	29/06/2020 18:00	29/06/2020	Pending		£10.00
£10	17/09/2020 16:00	17/09/2020 16:00	17/09/2020	Pending		£10.00
£10	17/09/2020 16:00	30/06/2020 16:00	30/06/2020	Pending		£10.00
£10	17/09/2020 16:00	15/09/2020 00:00	15/09/2020	Pending		£10.00
£10	17/09/2020 16:00	16/09/2020 18:00	16/09/2020	Pending		£10.00
£10	17/09/2020 16:00	29/06/2020 18:00	29/06/2020	Pending		£10.00
£10	17/09/2020 16:00	17/09/2020 16:00	17/09/2020	Pending		£10.00
£10	17/09/2020 16:00	30/06/2020 16:00	30/06/2020	Pending		£10.00
£10	17/09/2020 16:00	15/09/2020 00:00	15/09/2020	Pending		£10.00
£10	17/09/2020 16:00	16/09/2020 18:00	16/09/2020	Pending		£10.00
£10	17/09/2020 16:00	29/06/2020 18:00	29/06/2020	Pending		£10.00
£10	17/09/2020 16:00	17/09/2020 16:00	17/09/2020	Pending		£10.00
£10	17/09/2020 16:00	30/06/2020 16:00	30/06/2020	Pending		£10.00

[az38 · Accepted solution]

Hi @moeconsult 

try

Column = 
IF(ISBLANK([Updated]), [fee],
 IF([Status]="Cancelled" && ([Startdate] - [Updated]) > 2, 0, [fee])
)

[camargos88 · Accepted solution]

Hi @moeconsult ,

Try this custom column:

C = IF('Table (2)'[Update] = BLANK(); 'Table (2)'[fee]; IF('Table (2)'[Start Date] - 'Table (2)'[Update] > 2 && 'Table (2)'[Status] = "Cancelled"; 0; 'Table (2)'[fee]))

Ricardo

[az38 · Accepted solution]

Hi @moeconsult 

try

Column = 
IF(ISBLANK([Updated]), [fee],
 IF([Status]="Cancelled" && ([Startdate] - [Updated]) > 2, 0, [fee])
)