Forum Discussion
How to keep the last N rows from a log table
Hi all ! I have a Oracle log table that records some process events and this table is updated twice a week with a key formatted as a sort of progressive : YYYYnnn. For instance the 14th run of the ...
Thanks for replying me. I am not clear what is the meaning of column "VALUE" in your example: it does not mean anything to me. What the meaning of the contents 5,9,8,6,8, etc?
Other than this I have created the numeric for ANNO_SEQ_CARICAMENTO but trying to create a new column
"RANK" it says...
"La funzione 'RANKX' non è consentita come parte di espressioni DAX della colonna calcolata nei modelli DirectQuery." that is
"The 'RANKX' function is not allowed as part of calculated column DAX expressions in DirectQuery models."
This is the DAX command I entered:
rank_ASCaric = RANKX(TBL_BON_TABLES_EBDS_LOG ,TBL_BON_TABLES_EBDS_LOG[anno_seq_caricamento_num],,ASC,Dense)
Thanks!
Danilo