Thank you for the suggestion tamerj1 . Since its a direct query connection then relationship tab is not available.

I dont think backend team would add a column 😞 

I am able to get weekNo in a measure using  (WeeNum=WeeKNUM(Max(Table[Date]))
Is ther any way to pass this to get desired output?

Max sale at each week and monthy average of maximum data?