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...
Hi @Perez237,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
GENERATESERIES creates a calculated table. There is no concept of SELECTEDVALUE in a calculated table.
