Compare value between 2 dates to find gain/loss

[Madxfr]

Hello,

I would like to compare actual data from a table to another date selected by the user.

I need to find the gain and the loss and  get the actual state vs previous state for the date selected by the user.

You can find more explanation on my Previous post  and the project file here

Thanks to @lbendlin for his help.

I'm stucked when a new record (row) appears for the actual date, gain or loss total are wrong.

I tried different methods :

From my previous project, i create another table with only the actual data to compare with the full table

But without luck or succes.

Here is what it's already done

Thanks for your help

[Madxfr]

Hi,

Thanks.

What would be the best solution to get the desired result ? 

If needed i can change my data model.

[v-easonf-msft]

Hi, @Madxfr 

Currently, it is difficult to add  extra rows of dynamic records to the model. Although you manually create a summary table to summarize the data, the table visual created based on the summary table will always be unaffected by the slicer.

Best Regards,
Community Support Team _ Eason