Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
hi,
I need to implement the below logic in power bi in DAX:
If (JMS_DELIVERED_DATE_TIME is not NULL) and (FIRST_TOUCH_DATE_TIME is not NULL) and (LW_RECEIVE_START_DATE_TIME is not NULL ) then AVG (JMS_DELIVERED_DATE_TIME - FIRST_TOUCH_DATE_TIME )
Solved! Go to Solution.
@Anonymous wrote:hi,
I need to implement the below logic in power bi in DAX:
If (JMS_DELIVERED_DATE_TIME is not NULL) and (FIRST_TOUCH_DATE_TIME is not NULL) and (LW_RECEIVE_START_DATE_TIME is not NULL ) then AVG (JMS_DELIVERED_DATE_TIME - FIRST_TOUCH_DATE_TIME )
You would use the following syntax:
MeasureName = IF ( MAX ( 'Table'[Field1] ) <> "" && MAX ( 'Table'[Field2] ) <> "" && MAX ( 'Table'[Field3] ) <> "", TrueCondition, FalseCondition )
Comparing to "" will test for a null field. You could also use ISBLANK(). You need the MAX function to tease out the scalar value for the record as just referring to the field will return the entire column, and IF() cannot handle that.
Use the && operator to act as the AND, and you can use as many as you like. Using the AND() function limits you to two.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting
@Anonymous wrote:hi,
I need to implement the below logic in power bi in DAX:
If (JMS_DELIVERED_DATE_TIME is not NULL) and (FIRST_TOUCH_DATE_TIME is not NULL) and (LW_RECEIVE_START_DATE_TIME is not NULL ) then AVG (JMS_DELIVERED_DATE_TIME - FIRST_TOUCH_DATE_TIME )
You would use the following syntax:
MeasureName = IF ( MAX ( 'Table'[Field1] ) <> "" && MAX ( 'Table'[Field2] ) <> "" && MAX ( 'Table'[Field3] ) <> "", TrueCondition, FalseCondition )
Comparing to "" will test for a null field. You could also use ISBLANK(). You need the MAX function to tease out the scalar value for the record as just referring to the field will return the entire column, and IF() cannot handle that.
Use the && operator to act as the AND, and you can use as many as you like. Using the AND() function limits you to two.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |