Forum Discussion

Amitkr174's avatar
Amitkr174
Icon for Helper III rankHelper III
3 years ago

Date DAX Calculation

Hi, tamerj1  johnt75  parry2k Jihwan_Kim ThxAlot VahidDM      I am trying to create a DAX for the below case:- IF ( (I:O createddate) > Case Completion Date), then     (I:O createddate) - Case ...
Amitkr174's avatar
Amitkr174
Icon for Helper III rankHelper III
3 years ago

I am not able to send you the message. Error msg is below. 

 

Amitkr174's avatar
Amitkr174
Icon for Helper III rankHelper III
3 years ago

Sample data tamerj1 

Opp_DealR CaseNumberCreatedDateCase_Comp_dateoldvalueNewvalue
DR3622342 21975193/8/20232/26/202302 - Prospect05 - Solution Definition and Validation
DR3622342 21975195/25/20232/26/202305 - Solution Definition and Validation06 - Customer Commit
DR3622342 21975195/26/20232/26/202306 - Customer CommitClosed - Booked
DR3622342 21975195/26/20232/26/2023Closed - Booked07 - Execute to Close
DR3622342 21975196/1/20232/26/202307 - Execute to CloseClosed - Booked
DR3630255 22489143/20/20235/1/202301 - Pre Call Plan02 - Prospect
DR3630255 22489143/28/20235/1/202302 - Prospect03 - Opportunity Qualification
DR3630255 22489144/18/20235/1/202303 - Opportunity Qualification04 - Circle of Influence
DR3630255 22489145/18/20235/1/202304 - Circle of Influence05 - Solution Definition and Validation