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

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!