Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
sameh_00
New Member

Creating an average column

‎12-24-2022 06:14 AM

I have two tables with a date column in each one of them and theses data columns values are not exactly matched but fall within the same year and month

sameh_00_0-1671891079937.png

I need to create a new column in Table2 which contains the average of "OrdersCount" column in Table1 and its Dax query to be equivalent of this SQL query 

 

sameh_00_2-1671892130136.png

To get the following result

 

sameh_00_1-1671891173099.png

 

Labels:
Message 1 of 2
445 Views
0
1 REPLY 1
Ahmedx
Super User
Super User

‎12-24-2022 07:02 AM

solved your problem with power query

Please check attached pbix for more details
https://dropmefiles.com/TSDYE

Message 2 of 2
388 Views
0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

View All
Top Solution Authors
View All