I´m new at PBI and look for an aquivalent for the Sum IF Function in Excel:
I have to tables. 1. one is calles "KontElement" and contains the columns [CSAuftrag] and [Budget].
The 2. one contains several operations per each CS-Auftrag Number.
What I want to have:
CSAuftrag Budget Leistung (Sum!)
1 40 20
2 50 22
Anybody who can help me, I´m kind of lost right now... =(
Solved! Go to Solution.
the two table are related. They are related on column KontElementID, which is also good?
But the calculated numbers are wrong..
I created following calculated column:
IstLeistung = Calculate ( Sum (LN[ArbeitszeitInH])
there is another task:
WorkingTime_Jan = Calculate ( Sum (LN[ArbeitszeitInH]))
There is a column with dates in the table "LN". How can I improve the formula above to get only the operations of january 2018?
The format of the dates is: dd.mm.yyyy