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...
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])
    )

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 🙂

      • Tutu_in_YYC's avatar
        Tutu_in_YYC
        Super User
        4 years ago

        Hey Laura,
        Dont worry, it happens all the time to me too đŸ˜ DAX is not easy but it is certainly fun!