Converting sql into measure

[Anonymous]

Hello, i would like to convert this sql query into dax/ power query form 

Thanks in Advance

[Anonymous]

You can also import the data directly as a SQL Query, by copy pasting what you have written.

[PattemManohar]

@Anonymous Sample data will be really helpful. Anyway, I hope this is the logic you are looking for.

NewTable = FILTER(CROSSJOIN(['Dandenong test data'],[Range$]),[Range$].[Date]>=['Dandenong test data'].[Start] && [Range$].[Date]<=['Dandenong test data'].[End])