Forum Discussion
sameh_00
3 years agoNew 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
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
To get the following result
1 Reply
- AhmedxSuper User
solved your problem with power query
Please check attached pbix for more details
https://dropmefiles.com/TSDYE