Calculate week on week sales in Power BI - Weekly Time Intelligence in Power BI скачать в хорошем качестве

Calculate week on week sales in Power BI - Weekly Time Intelligence in Power BI

In this video, we speak about Week over Week/ Weekly Time Intelligence Calculations in DAX. We create 5 measures that involve week over week Calculations. These measures will work in both Excel PowerPivot and in Power BI 1-Sales Previous Week: This will give you the sales for the previous week 2-Sales Same Day Last Week: This will give you the sales for the same day in the last week. This enables you to compare Monday of this week to Monday of the last week for example. 3-Sales Same Day Same Week Last Month: This will give you the sales for the same day and the same week in the last month. This allows you to compare Monday of the 1st week of April to Monday of the 1st week of March for example! 4- Sales Same Week Last Year: This allows you to get the sales for the same week in the previous year. For example, compare the sales for the 3rd week this year to the sales for the 3rd week last year. 5-Sales Same Week Same Day Last Year: This allows you to compare the sales for a particular day of a particular week this year to the same day in the same week the last year. For example, compare sales on Monday of the 4th week this year to Monday of the 4th week last year. This video can help answer the following questions: How do I calculate/get the sales for the previous week/last week? How do I calculate/get the sales for the same day last week? How do I calculate/get the sales for the same in the same week in the previous/last month? How do I calculate/get the sales for the same week in the previous/last year? How do I calculate/get the sales for the same week and the same day in the previous/last year? Download PBIX and dataset files here: https://tinyurl.com/7wc23ukb GET 15% OFF my Excel PowerPivot for beginners Course. Use discount code YOUTUBE15 at checkout (Limited time offer!) https://tinyurl.com/4ayp2457 ****My online Excel Courses**** https://www.excelbonanza.com/courses/ #dax #Timeintelligence #powerbi