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

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