Forum Discussion

sameh_00's avatar
sameh_00
New Member
3 years ago

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