Power BI Error

[Laura0403]

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

[Laura0403]

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]

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
)

[Laura0403]

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]

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

[Laura0403]

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]

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
)

[Tutu_in_YYC · Accepted solution]

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