Agreggate values by date by category and obtain date-based averages

[lf2606]

Assume I have a dataset that contains transactions in which there are these columns

I wish to obtain data that would look like this: 

So ideally for any given time range I could have something like this at the end: 

Week X/1/23 - X/7/23

I'm sorry for making such a complex question but I'm fairly new to PowerBI/DAX and I'm not sure how to obtain those values and then graph them through power bi.   

I know how to do this in excel but it is very time-consuming to export it from source to excel, then obtain tables, then import it in PowerBI to graph it. Any ideas as of how to make all the calculations to use for visuals in PowerBI would be appreciated.

Thanks!

[Anonymous · Accepted solution]

Hi @lf2606 ,

Please check if this is the output you expect.

Sum of Daliy Qty = SUM('Table'[Quantity])

Avg by client = CALCULATE(AVERAGE('Table'[Price]),ALLEXCEPT('Table','Table'[Client]))

Avg by date = CALCULATE(AVERAGE('Table'[Price]),ALLEXCEPT('Table','Table'[Date]))

Avg by date and client = AVERAGE('Table'[Price])

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[lf2606]

Thank you!