Forum Discussion

dfeeney's avatar
dfeeney
New Member
2 years ago
Solved

Compare reports over time

I have a number of excel reports that are generated every fortnight.  They detail all the positions in my organisation as well as the pay rate, job title, occupants etc...   Our finance team are ta...
  • amitchandak's avatar
    2 years ago

    dfeeney , You can append two reports with dates in power query and can then use two date slicer and measures to compare data

    Power BI How to use/compare two Date/Period slicers: https://youtu.be/WSeZr_-MiTg

     

    You can use calculation groups to reduce measures