Forum Discussion

joe_2802's avatar
joe_2802
New Member
8 years ago
Solved

Value comparison between dates based on filters

Trying to achieve the following and would very much appreciate any help:   Report 1 (Date Filter): Date Category Carrots 02.03.2017 Donald 2.630.266.580 02.03.2017 Bugs Bunny 113.20...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

joe_2802 assuming data is in 2 tables and hooked to the date dimension. if it isnt go to power query and duplicate date as a step

 

change = 

var dat1value = calculate(sum(value), filter(table1, table1[date] = [filter1date])

var dat2value = calculate(sum(value), filter(table2, table2[date] = [filter2date])

 

return dat1value - dat2value

 

  • joe_2802's avatar
    joe_2802
    New Member
    8 years ago

    Thanks! Have to walk, before I run, apologies in advance:

    Data is one table.

     

    I think I am almost able to put the path to solving it together, but I am not sure what to do specifically in terms of the solution.