cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Psycho
Frequent Visitor

Creat a comparative conditions

Hello together!

 

I have a question for the creation of certain conditions.

 

I want to calculate following, but i dont know the syntax:

 

02 Dur.Bestmge.AktJ = if(Tabelle1[Monat] = "End.Best.Mge.AktJ.02" ; ....

 

....   (the  value [Bestand] of this row + the value [Bestand] of that row, with the same value in the column [Artikelnummer] and the value "End.Best.Mge.AktJ 01" in the column [Monat]) divided by 2

 

 

Unbenannt.png

 Have someone a solution for me?
 
Thanks and greetings.
1 ACCEPTED SOLUTION
mpo
Helper II
Helper II

If I understood you correctly, try

 

02 Dur.Bestmge.AktJ = if(Tabelle1[Monat] = "End.Best.Mge.AktJ 02",
Tabelle1[Bestand]+LOOKUPVALUE(Tabelle1[Bestand],
Tabelle1[Artikelnummer],Tabelle1[Artikelnummer],
Tabelle1[Monat],"End.Best.Mge.AktJ 01"),0)

View solution in original post

2 REPLIES 2
mpo
Helper II
Helper II

If I understood you correctly, try

 

02 Dur.Bestmge.AktJ = if(Tabelle1[Monat] = "End.Best.Mge.AktJ 02",
Tabelle1[Bestand]+LOOKUPVALUE(Tabelle1[Bestand],
Tabelle1[Artikelnummer],Tabelle1[Artikelnummer],
Tabelle1[Monat],"End.Best.Mge.AktJ 01"),0)

View solution in original post

Psycho
Frequent Visitor

Yes, that´s what I want. Wonderfull. Thank you very much.

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Top Solution Authors