my table has new and lost customers year after year. how can i extract only the new customer year on year and in an other table the lost customer including their name?
This is so frustrating. I have 7 years of revenue data from Xero in an excel spread sheet. Going down the page I have the individual line items that make up revenue, and going horizontally across the columns I have the income from each month. All you tube videos showing income analysis though has the date in rows going down the page, and I cannot for the life of me find anything else. Do you have a video showing how to use a pivot table to analyse income when the months are in columns not in rows?
![Calculate Difference This Year vs Last Year In Power BI With DAX [2022 Update]](/img/1.gif)
my table has new and lost customers year after year. how can i extract only the new customer year on year and in an other table the lost customer including their name?
Hello dear .
Why in my sheet doesn't order of yearly quart and month
Thanks Chris. Very Interesting!! : )
Thank you John.
This is so frustrating. I have 7 years of revenue data from Xero in an excel spread sheet. Going down the page I have the individual line items that make up revenue, and going horizontally across the columns I have the income from each month. All you tube videos showing income analysis though has the date in rows going down the page, and I cannot for the life of me find anything else. Do you have a video showing how to use a pivot table to analyse income when the months are in columns not in rows?
It sounds like you have cross tabular data. If that's the case, you power query to make it tabular. ruclips.net/video/jZNxJ7lopwg/видео.html
CAN WE MERGE MULTIPLE PIVOTS IN ONE PIVOT TABLE?
Hi. I am trying to create year over year analysis for 100 customers three years 12 months per year all in the same Excel spreadsheet
For just two years not three