Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Parsing issues with calculation

Hi,   Im new to powerbi and coming from tableau. I wanted to convert a calculation with which Im facing multiple parsing issues as i want a date to be returned and if date is not returned then it ...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous,

     

    Again, please check this one.

     

    Column 2 = 
IF (
    IF (
        Table1[Current Location] = "sold"
            || Table1[Current Location] = "Factory",
        TRUE (),
        FALSE ()
    )
        = FALSE (),
    "NA",
    IF (
        Table1[Est delive dt] < DATE ( 2018, 09, 18 ),
        "Data Unavailable",
        ""
            & CALCULATE (
                MIN ( Table1[Est delive dt] ),
                ALLEXCEPT ( Table1, Table1[Current Location] )
            )
    )
)

     

    Also please find the file attached.

     

    Regards,

    Frank

v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Anonymous,

 

Do you mean when you create the column using the formula as I offered you got this error message? Or do you want to do some calculation using the calculated Column? As you know, it is a text column, so you cannot do that.

 

Regards,

Frank

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Frank,

 

The calculation that you offered shows this error.