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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Your new calculation by logic should work but i dont know why it is still showing the parsing error.

I see that the date is converted into string by using "" 

 

 

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

Hi Anonymous,

 

That should be the issue of your column [Est delive dt], that should be in the format of date. Please change the data type of the column and try again, if it doesn't work, Could you please share your pbix to me?

 

Regards,

Frank

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Frank,

     

    This worked perfect now.

    Thanks a ton.

     

    Also just wanted to know since the highlighted info is repeated twice, can I "group by" this info ?