Forum Discussion

AvPowerBI's avatar
AvPowerBI
Icon for Post Patron rankPost Patron
5 years ago
Solved

Calculated Column Issue - Single Value

Hi,   I am trying to write a calculated column based on the following logic: IF Description from the Type Table is equal to "First Day" or "Second Day"  THEN how many Minutes between StartDateTime...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi AvPowerBI ,

     

    You will need to define StartDateTime and EndDateTime in the Type table first.

    Please check the following formula.

    Column = 
var _start = LOOKUPVALUE('Call Fact'[StartDateTime],'Call Fact'[id],'Type'[id])
var _end = LOOKUPVALUE('Call Fact'[EndDateTime],'Call Fact'[id],'Type'[id])
var _diff = IF('Type'[Description] IN {"First Day","Second Day"},DATEDIFF(_start,_end,MINUTE))
return
IF(_diff>480,45,_diff)

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi AvPowerBI ,

 

You will need to define StartDateTime and EndDateTime in the Type table first.

Please check the following formula.

Column = 
var _start = LOOKUPVALUE('Call Fact'[StartDateTime],'Call Fact'[id],'Type'[id])
var _end = LOOKUPVALUE('Call Fact'[EndDateTime],'Call Fact'[id],'Type'[id])
var _diff = IF('Type'[Description] IN {"First Day","Second Day"},DATEDIFF(_start,_end,MINUTE))
return
IF(_diff>480,45,_diff)

 

Best Regards,

Jay