Forum Discussion
Average column in Matrix table
Hi All, I need to include Average column in matrix table that should look like the table below. Can anyone show how I can include the average column in the matrix table? [Updated] Also, the w...
Thank you for your reply! I do realise I did not explain my scenario clearly. Have updated the post with more info.
I actually have a list of weeks in the Dim_Period, however, I only want to display rolling 5 weeks based on the selection in Week slicer (i.e., If Week slicer is filtered to Wk2, Matrix table will display Wk6 to Week 2). For this, I already have a measure (Actual_5wks)to display the rolling 5 weeks data.
Anonymous , That last column is kind of a hybrid table need. I shared links for a workaround and the idea.
Or each week need to me a measure