Forum Discussion
Switching hot(current) and cold(previous) data values on the same table visual using switch/slicer
I am kind of stuck in implemented this idea. Could anybody please help. If I choose Hot, i want to display the current month data and rest will all be the previous. I have already splitted the da...
Phillip I am not sure if you go the solution but the best approach will be to write a measure that aggregates your data in cold then add that to the data in hot. For example ColdMeasure = Sum(cold[data]) and HotMeasure = Sum(Hot[data]) then Hot/Cold= ColdMeasure + HotMeasure. You can use variables also if you want. But this should give you the desired result.