Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Power BI Error

Hello,

unfortunately I am not a professional and need urgent help. 

I have the following formula as output:

Unfortunately, there is then an error message in the data. Now I have tried to fix this error message as follows:

That didn't help either. I no longer know what to do.

 

Can someone help me? 

 

Thanks, Laura

Need Help
  • Tutu_in_YYC's avatar
    Tutu_in_YYC
    4 years ago

    Hallo Laura,
    Lets try and fix TopDealsAngebotsDatum first.

    Try this:

    TopdealAngebotsdatum =
    IF(
       ISERROR( LOOKUPVALUE(Angebote[datum_ang],Angebote[TopDeal],Auftraege[TopDeal])),
       BLANK(),
       LOOKUPVALUE(Angebote[datum_ang],Angebote[TopDeal],Auftraege[TopDeal])
    )

7 Replies

  • Tutu_in_YYC's avatar
    Tutu_in_YYC
    Super User
    4 years ago

    Hallo Laura,
    Lets try and fix TopDealsAngebotsDatum first.

    Try this:

    TopdealAngebotsdatum =
    IF(
       ISERROR( LOOKUPVALUE(Angebote[datum_ang],Angebote[TopDeal],Auftraege[TopDeal])),
       BLANK(),
       LOOKUPVALUE(Angebote[datum_ang],Angebote[TopDeal],Auftraege[TopDeal])
    )

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hello Tutu,
    I changed this. Now it looks like this:

    And the result looks like this:

    so the error ist gone because blank, I got this one 😄 

    Can you maybe help me with fixing the 

    TopDeal_Yes-no = if('Aufträge'[TopdealAngebotsdatum]<='Aufträge'[datum_ab]&&'Aufträge'[TopdealAngebotsdatum]+7>'Aufträge'[datum_ab],1)
    • Tutu_in_YYC's avatar
      Tutu_in_YYC
      Super User
      4 years ago

      Make sure TopdealAngebotsdatum and datum_ab have data type Date

       



      TopDeal_Yes-no = 

      IF(
        'Aufträge'[TopdealAngebotsdatum] <='Aufträge'[datum_ab] &&
        'Aufträge'[TopdealAngebotsdatum]+7>'Aufträge'[datum_ab],
        1,
        0
      )

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    The Data typ is Date.

    Power BI is finding a few, but not all of them. There should be Dates from every Week this year 😞

    • Tutu_in_YYC's avatar
      Tutu_in_YYC
      Super User
      4 years ago

      Did you try this?

      TopDeal_Yes-no = 

      IF(
        'Aufträge'[TopdealAngebotsdatum] <='Aufträge'[datum_ab] &&
        'Aufträge'[TopdealAngebotsdatum]+7>'Aufträge'[datum_ab],
        1,
        0
      )
      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        This is working, I feel so stupid right now. 

        Thank you very much.

         

        I guess the Problem with the "TopDealName" and the "TopdealAngebotsdatum" is somewhere else. I need to first fix the other problem. 

         

        Thank you very much 🙂