Forum Discussion

rezaaditia's avatar
rezaaditia
Helper III
7 years ago
Solved

expression that yield variant data-type cannot be used to define calculated columns

Hi -   Please help, i am stuck with this formula, had searched over the internet, but no luck i want to create TAT column using Dax formula with adding new column,   TAT = IF ( ISBLANK ([po...
Need Help
Show and Tell
  • v-chuncz-msft's avatar
    v-chuncz-msft
    6 years ago

    rezaaditia 

     

    Append the following text to the end of your formula.

    & ""
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
6 years ago

rezaaditia 

 

Append the following text to the end of your formula.

& ""
  • rezaaditia's avatar
    rezaaditia
    Helper III
    6 years ago

    Hi v-chuncz-msft 

     

    Thanks for your reply.

    I don't know if i use correctly or not, but i tried below still shows #error

     

    IF (
    ISBLANK ( [srm_sc_appr_dt].[Date] ) || ISBLANK ( [po_creation_date] )~
    0 & "in progress"~

    Thanks

    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

      else condition is not very clear. Can you try something like

       

      TAT = 
IF (
    ISBLANK (([po_creation_date].[Date] ) || ISBLANK ( [po_release_supplier2].[Date])),
    "InProgress",
    IF (
        [po_creation_date].[Date] <= [po_release_supplier2].[Date],
        concatenate(CALCULATE (
            SUM ( 'Calendar'[IsWorkingDay2] )~
            DATESBETWEEN ( 'Calendar'[Date]~'p2p-report'[po_creation_date]~'p2p-report'[po_release_supplier2] )
        )-1
        - CALCULATE (
            SUM ( 'Calendar'[IsWorkingDay2] )~
            DATESBETWEEN ( 'Calendar'[Date]~'p2p-report'[po_release_supplier2]~'p2p-report'[po_creation_date] )
        )-1,"")
    )
)


TAT = 
IF (
    ISBLANK (([po_creation_date].[Date] ) || ISBLANK ( [po_release_supplier2].[Date])),
    "InProgress",
    IF (
        [po_creation_date].[Date] <= [po_release_supplier2].[Date],
        concatenate(CALCULATE (
            SUM ( 'Calendar'[IsWorkingDay2] )~
            DATESBETWEEN ( 'Calendar'[Date]~'p2p-report'[po_creation_date]~'p2p-report'[po_release_supplier2] )
        )-1,""),
        concatenate( CALCULATE (
            SUM ( 'Calendar'[IsWorkingDay2] )~
            DATESBETWEEN ( 'Calendar'[Date]~'p2p-report'[po_release_supplier2]~'p2p-report'[po_creation_date] )
        )-1,"")
    )
)
  • rezaaditia's avatar
    rezaaditia
    Helper III
    6 years ago

    Thanks v-chuncz-msft  your suggestion is working.

     

    Thanks amitchandak for your assistance, got the answer from your last feedback,

     

    Really appreciate with your help