Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
sameh_00
New Member

Creating an average column

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

 

1 REPLY 1
Ahmedx
Super User
Super User

solved your problem with power query

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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