topic Re: DAX Query: Relative difference visible previous day in DAX Commands and Tips

DAX Query: Relative difference visible previous day

Anonymous — Tue, 03 Oct 2023 19:10:59 GMT

I have the following query table yet (i'm not interested in a Table or Matrix visual):

How can i get a new column with the relative difference of one of the visible day with the previous visible day?

Thanks for your help

Re: DAX Query: Relative difference visible previous day

OwenAuger — Wed, 04 Oct 2023 00:24:03 GMT

Hi Anonymous

You can use the OFFSET function.

Here is an example:

Test = VAR SummarizedTable = SUMMARIZE ( 'Table Principale', [Date Commande], "Somme Cash-Flow", SUM ( 'Table Principale'[Prix total avec rabais] ) ) VAR AddPrevious = ADDCOLUMNS ( SummarizedTable, "Somme Cash-Flow Previous", -- Guaranteed to be a single row SELECTCOLUMNS ( OFFSET ( -1, SummarizedTable, ORDERBY ( 'Table Principale'[Date Commande] ) ), [Somme Cash-Flow] ) ) RETURN AddPrevious

I would also recommend changing SUMMARIZE (...) to ADDCOLUMNS ( SUMMARIZE (... ), ... ), but that's a best practice suggestion rather than a necessity here.

Regards

Re: DAX Query: Relative difference visible previous day

Anonymous — Wed, 04 Oct 2023 06:41:18 GMT

Thanks a lot! That works like a charm.