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,

 

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,

     

    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.

  • 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 ?