Forum Discussion
topazz11
Helper III
Helper IIIadding variance into table
is there a way to add variance between current and prior into the table? current and prior data are in the same table but I am not sure how to add the variance data. Thank you, type group ...
Hi topazz11
Instead of adding extra rows to your data and potentially slow down refresh and increase your semantic model's footprint, use calculation groups instead so the same logic is applied to the measures added to a visual. Please see the attached sample pbix.
danextian
Super User
Super UserHi topazz11
Instead of adding extra rows to your data and potentially slow down refresh and increase your semantic model's footprint, use calculation groups instead so the same logic is applied to the measures added to a visual. Please see the attached sample pbix.
topazz11Thank you, this works. I have never used this before. how does it filter current, prior or variance without relationship? it is mystery..