cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## avg change in last 7 days for orders

Hi evryone,

I need help with the calculation:

I heve this measure:

unique_outlet_order_30d = CALCULATE([distinct orders],DATESBETWEEN('Date_Created_Date'[Date],LASTDATE('Date_Created_Date'[Date])-30, LASTDATE('Date_Created_Date'[Date])))

I need to calculate the change between today and yesterday for the last 7 days and to do avarge about the score

for example:
 orders in last 30 days change 29/05/2023 10 3 28/05/2023 7 -1 27/05/2023 8 3 26/05/2023 5 -4 25/05/2023 9 4 24/05/2023 5 -1 23/05/2023 6 6 avg 1.4

there is a way to calculate it with a measure?
2 ACCEPTED SOLUTIONS
Super User

@sapirmarko , Try like

Calculate(AVERAGEX(Values('Date'[Date]), [This Day] - [diff]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-7,DAY) )

Community Support

Hi, @sapirmarko

You can try the following methods.

Measure:

``````Change =
Var _Previousdate=MAXX(FILTER(ALL('Table'),[Date]<SELECTEDVALUE('Table'[Date])),[Date])
Var _Previousorder=CALCULATE(SUM('Table'[orders in last 30 days]),FILTER(ALL('Table'),[Date]=_Previousdate))
Var _Currentorder=SUM('Table'[orders in last 30 days])
Return
_Currentorder-_Previousorder``````
``Result = IF(HASONEVALUE('Table'[Date]),[Change],AVERAGEX('Table',[Change]))``

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 REPLIES 3
Helper I

Thanks! it's working great!

Community Support

Hi, @sapirmarko

You can try the following methods.

Measure:

``````Change =
Var _Previousdate=MAXX(FILTER(ALL('Table'),[Date]<SELECTEDVALUE('Table'[Date])),[Date])
Var _Previousorder=CALCULATE(SUM('Table'[orders in last 30 days]),FILTER(ALL('Table'),[Date]=_Previousdate))
Var _Currentorder=SUM('Table'[orders in last 30 days])
Return
_Currentorder-_Previousorder``````
``Result = IF(HASONEVALUE('Table'[Date]),[Change],AVERAGEX('Table',[Change]))``

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User

@sapirmarko , Try like

Calculate(AVERAGEX(Values('Date'[Date]), [This Day] - [diff]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-7,DAY) )

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors