Forum Discussion
Prior year Matrix column
Hi, I have a matrix table in my report that I want to show total sales by employee, per month and have a total sales for the previous year. I have a SQL dimension called DimEmployee, (EmpId(PK)...
First, sample data and measure formulas are of great assistance. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490.
Also, See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008