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

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
)