Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Laura0403
Frequent Visitor

Power BI Error

Hello,

unfortunately I am not a professional and need urgent help. 

I have the following formula as output:

Laura0403_0-1648474182739.png

Unfortunately, there is then an error message in the data. Now I have tried to fix this error message as follows:

Laura0403_1-1648474219937.png

That didn't help either. I no longer know what to do.

 

Can someone help me? 

 

Thanks, Laura

1 ACCEPTED SOLUTION
Tutu_in_YYC
Resident Rockstar
Resident Rockstar

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

View solution in original post

7 REPLIES 7
Laura0403
Frequent Visitor

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 😞

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
)

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 🙂

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

Laura0403
Frequent Visitor

Hello Tutu,
I changed this. Now it looks like this:

Laura0403_0-1648478715029.png

And the result looks like this:

Laura0403_1-1648478775035.png

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)

Make sure TopdealAngebotsdatum and datum_ab have data type Date

 

Tutu_in_YYC_0-1648479098046.png

TopDeal_Yes-no = 

IF(
'Aufträge'[TopdealAngebotsdatum] <='Aufträge'[datum_ab] &&
'Aufträge'[TopdealAngebotsdatum]+7>'Aufträge'[datum_ab],
1,
0
)

 

Tutu_in_YYC
Resident Rockstar
Resident Rockstar

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

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors