I hope that you can help me. I have a data set and i need to know the difference between the 2 column in a matrix visualization, i need it to look like this -
There is also a MonthY filter for this visualization so that the consumer can add the new month and remove the month that is not required. This will only be a two month Comparison, however the consumers might need to go back to get history. All the values are in one column in the data tables.
having a separate date table will actually save space and allow you to you use built in time itnelligence, cause for each date you store Year, month etc. only once and not per each row of your dataset, see here:
can you also explain how the MonthY filter would work in this case?
Right now I see 2 possible solutions:
1) you will need a table that would have a column that would have all possible months listed as well as the "Difference" label, 2) you can create a generic FirstMonth/Second Month Measures that would be filtered by MonthY slicers and then have 3rd measure Difference that would calculate variance between the 2
Did I answer your question? Mark my post as a solution! Thank you for the kudos 🙂