How Can I get these T-SQL in dax?

[gabrielInfoshot]

Hi

How Can I get these T-SQL in a new virtual table using DAX?

SELECT TASKS.taskID, timeSet.timeByDay , Tasks.avgField
FROM TASKS
JOIN
timeSet on
timeset.timeByDay >=tasks.startData and
timeset.timebyDay <= tasks.EndData

Thank You

[v-piga-msft]

Hi @gabrielInfoshot ,

It seems that you want to convert to T-SQL to DAX in Power BI. 

You could have a reference of this blog from sql to dax projection . 

If you still need help, please share your data sample and your desired output so that I could have a test on it and get the solution.

Best  Regards,

Cherry

[gabrielInfoshot]

Thanks for you reply.

Im still trying to do my conversion. I had already seen this blog but I couldn't find my solution there because my T-sql Join is a different join . Im trying to joinning a range of dates using these feature:

timeset.timeByDay >=tasks.startData and
timeset.timebyDay <= tasks.EndData

I have to increase the granulation of my data in the all days of a range of dates between tasks.startData and tasksEnd Data. In T-SQL it works perfectly, but in DAX i have no Idea to how can I use one "join" with a range of values instead of the "=" symbol.

[v-piga-msft]

Hi @gabrielInfoshot ,

If it is convenient, could you share your data sample and your desired output in Power BI so that I could have a test on it.

In addition, you also could share your T-SQL queries which could reproduce your scenairo so that I could copy and have test on it.

Best Regards,

Cherry