cancel
Showing results for
Did you mean:
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

Have someone a solution for me?

Thanks and greetings.
1 ACCEPTED SOLUTION
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)`
2 REPLIES 2
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)`
Frequent Visitor

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

Announcements

#### Manage your user group events

Check out the News & Announcements to learn more.

#### 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.

#### 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
Top Kudoed Authors