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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. 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
Community Champion
Community Champion

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
Community Champion
Community Champion

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
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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