Hi,
been working through a couple of solutions in order to compare output of two datasets dynamically. In general, I have two deals tables - each are the same exact table structure with the only difference being the snapshot date that each data was taken as of.
the first way I've attempted to solve is by using DAX. Problem I've had with this is that scalar output measures and table output measures don't play nice together so I can't write a measure with selectedvalue(snapshotdate1) and generate a list, and then determine if any of the table values are found in a table output generated from selectedvalue(snapshot date2).
second way I can do this is with a parameterized stored procedure that takes input from power Bi for the beginning snapshot date and ending snapshot date and runs through procedure logic the way I need it to. Problem here is getting the input from somewhere in power Bi service back to stored procedure parameters and then rendering output to power Bi.
Any thoughts or has anyone tried something similar before?
