Forum Discussion

loginarun's avatar
loginarun
Frequent Visitor
1 year ago
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...
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.

  • loginarun's avatar
    loginarun
    Frequent Visitor
    1 year ago

    Need same day of previous Month Example  if 4-Apr-2022 is monday the previous month of first monday like 3-Mar-2022 it will show
    below the line chart