Inner Join

[Krunoslav123]

I have simple problem with inner join in Power BI Desktop . My problem is realted to this problem http://stackoverflow.com/questions/20790681/split-range-of-dates-into-individual-records-keeping-ids

I successfully managed to solve the problem with a SQL query but a major problem is that performance of this query is executed very slowly. Now i'm trying to find a solution within the power bi desktop but unsuccessfully. 

Here is my sample data 

DateTimeFrom	DateTimeTo	Name	Value
3.1.2016 22:00	4.1.2016 1:00	1	0,33
4.1.2016 2:00	4.1.2016 3:00	1	0,44
3.1.2016 23:00	4.1.2016 2:00	2	1,22

and here is Expected results

Name	DateTime	Value
1	3.1.2016 22:00	0,33
1	3.1.2016 23:00	0,33
1	4.1.2016 0:00	0,33
1	4.1.2016 1:00	0,33
1	4.1.2016 2:00	0,44
1	4.1.2016 3:00	0,44
2	3.1.2016 23:00	1,22
2	4.1.2016 0:00	1,22
2	4.1.2016 1:00	1,22
2	4.1.2016 2:00	1,22

I also have DimDateTime with generated all values .

[Krunoslav123 · Accepted solution]

OK i think that i found sollution : 

Crate table : 

Inner_Join = FILTER (
CROSSJOIN ( 'DimDateTime'; sample data  );
'DimDateTime'[DateTime]>='sample data'[DatumOdMRound] && 'DimDateTime'[DateTime] < 'sample data'[DatumDoMRound]
)