Forum Discussion
Matrix report
I am trying to create a report which shows the data of the pervious year data from the selected year in a slicer in a yearly format & the selected year data slicer in months.. For example: I sele...
It there a way to integrate that in the existing calander table
Greg_Deckler That is what i was actully trying to achive but need that to be a little dynamic like if i select a different year in a slicer it should use that and change the LY and PY accordingly to that.
Anonymous Might be possible if you construct your measure just right. Put all of your years and months into a disconnected table and construct a measure so that it only returns values based on certain conditions. I mocked up a really simple example. PBIX attached below signature. So, the only columns that get displayed are the ones where the measure returns a value. With the proper logic you should be able to get it to do what you want.