Hello got some problems with selected value in a created database but I don't receive any value, just blank space;
Item_consommation_calcul =
SELECTCOLUMNS(
FILTER(
Items,
RIGHT(Items[ITEM], 2) = "RB" || RIGHT(Items[ITEM], 3) = "SDS"
),
"Articles", [ITEM],
"Selection",
VAR Selection = SELECTEDVALUE(TableMethods[Value])
RETURN Selection,
"Entree",
VAR CurrentItem = [ITEM]
RETURN COALESCE(
SUMX(
FILTER(
Items_Consommation,
Items_Consommation[ITEM] = CurrentItem &&
Items_Consommation[TRANSACTION_QUANTITY] >= 0 &&
(
('TableMethods'[Valeur Methods] = 1 && Items_Consommation[TRANSACTION_DATE] >= DATE(YEAR(TODAY()) - 'LastNYears'[Valeur LastNYears], 1, 1)) ||
('TableMethods'[Valeur Methods] = 2 && YEAR(Items_Consommation[TRANSACTION_DATE]) = 'Année'[Valeur Année])
)
),
Items_Consommation[TRANSACTION_QUANTITY]
),
0
),
"Sortie",
VAR CurrentItem = [ITEM]
VAR SelectedMethod = SELECTEDVALUE(TableMethods[Value])
RETURN COALESCE(
SUMX(
FILTER(
Items_Consommation,
Items_Consommation[ITEM] = CurrentItem &&
Items_Consommation[TRANSACTION_QUANTITY] < 0 &&
(
('TableMethods'[Valeur Methods] = 1 && Items_Consommation[TRANSACTION_DATE] >= DATE(YEAR(TODAY()) - 'LastNYears'[Valeur LastNYears], 1, 1)) ||
('TableMethods'[Valeur Methods] = 2 && YEAR(Items_Consommation[TRANSACTION_DATE]) = 'Année'[Valeur Année])
)
),
Items_Consommation[TRANSACTION_QUANTITY]
),
0
)
)
That's the formula I want to do, the generates series are :
That's the formula I want to do, the generates series are :
Année = GENERATESERIES(2020, 2100, 1)
Also the selection is supposed to be done as indicated,
Also the selection is supposed to be done as indicated,
Always returning blank
Please and thanks for your Help...
GENERATESERIES creates a calculated table. There is no concept of SELECTEDVALUE in a calculated table.
