Try to display KPI after scripting Peek function

[Sami1]

Hello every one,

I am using Peek function like this:

AR_fournisseurs:
LOAD
"A",
"B",
"C",
"D",
"E",
"F",
"G",
"H",
"I"
FROM [lib://DataFiles/ARC CDES FOURNISSEURS 2023.xlsx]
(ooxml, embedded labels, table is [Synthèse ARC 2023]);

let Taux_AR_sous_48h = Peek('G',14,'AR_fournisseurs');

I would like to display the value at row 14 from the field "G" in a KPI and I get the following result:

Any Idea?

[marcus_sommer]

In some way you are not calling the variable-content else displaying the variable-name. What happens if you put a = before the call?

Beside this you are not getting the 14. row else the 15. because the peek-index starts by 0.

I don't know what your data contain and what are the requirements within the views but I think I wouldn't do in this way else adding: rowno() as RowNo to the load and then querying the value per:

only({< RowNo = {14}>} G)

[Sami1]

Thanks, I put the wrong row, it works better with row number 13.