Forum Discussion
Solved
undefined
The file “exercise_data.xlsx” contains two sheets of data: “sales” which contains the sales for a single product sold by an e-shop: payment_type = the payment type of the order order_datetim...
Hi loginarun ,
Below is my test data.
Create a measure showing sales on the same day of the previous week.Sales previous week = CALCULATE( SUM(sales[total_amount]), 'sales'[order_datetime]=MAX('sales'[order_datetime])-7, ALLEXCEPT('sales',sales[order_datetime]) )
Then create a measure showing the percentage change in sales.Percentage change per week = DIVIDE(SUM(sales[total_amount])-[Sales previous week],[Sales previous week])
Place the measures and table fields into the table visual as shown below.
Please see the pbix for reference.
Best Regards,
Dengliang Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the Support