Forum Discussion
Solved
Showing difference between two rows with date selection
Hi all, I have a table like this: Materialnumber Date Value 100 01.01.2021 100 100 02.01.2021 100 100 03.01.2021 200 The goal is that the user can select 2 dates and Po...
flownfluid , assuming dates are selected in a single slicer
measure =
Var _Min = MINX(allselected('Date'), 'Date'[Date]) //date table assumed
Var _Max = MAXX(allselected('Date'), 'Date'[Date])
return CALCULATE(SUM(Table1[Value]), filter(Table1, Table1[date]=_max)) -CALCULATE(SUM(Table1[Value]), filter(Table1, Table1[date]=_min))
v-janeyg-msft
Community Support
Community SupportHi, flownfluid
If I understand your needs, you can do this:
1. Create a single date list as slicer.
Like this:
Table 2 = DISTINCT('Table'[Date])2. Create a measure to show the difference.
Like this:
Measure =
var a=MINX( DISTINCT('Table 2'[Date]),[Date])
var b=MAXX( DISTINCT('Table 2'[Date]),[Date])
var c=SUMX(FILTER(ALL('Table'),[Date]=a&&[Materialnumber]=SELECTEDVALUE('Table'[Materialnumber])),[Value])
var d=SUMX(FILTER(ALL('Table'),[Date]=b&&[Materialnumber]=SELECTEDVALUE('Table'[Materialnumber])),[Value])
return d-c
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.
Best Regards,
Community Support Team _ Janey