New table - list between two dates | Microsoft Fabric Community

Anonymous

Not applicable

4 years ago

Greg_Deckler , I am sorry this is not what I meant. I tried it in Power Query, but I am not sure it would work. Wouldn't be rather a DAX function that could do show one line for each period? See for example what it would looks like for project 1 :

Project	Ressource name	Period	Hrs A-B	Hrs A-C
1	John Smith	202113	2	0
1	John Smith	202114	2	0
1	John Smith	202115	2	0
1	John Smith	202116	2	0
1	John Smith	202117	2	0
1	John Smith	202118	2	0
1	John Smith	202119	2	0
1	John Smith	202120	2	0
1	John Smith	202121	2	0
1	John Smith	202122	2	0
1	John Smith	202123	2	0
1	John Smith	202124	2	0
1	John Smith	202125	2	0
1	John Smith	202126	2	0
1	John Smith	202127	2	0
1	John Smith	202128	2	0
1	John Smith	202129	2	0
1	John Smith	202130	2	0
1	John Smith	202131	2	0
1	John Smith	202132	2	0
1	John Smith	202133	2	0
1	John Smith	202134	2	0
1	John Smith	202135	2	0
1	John Smith	202136	2	0
1	John Smith	202137	2	0
1	John Smith	202138	2	0
1	John Smith	202139	0	6
1	John Smith	202140	0	6
1	John Smith	202141	0	6
1	John Smith	202142	0	6
1	John Smith	202143	0	6
1	John Smith	202144	0	6
1	John Smith	202145	0	6
1	John Smith	202146	0	6
1	John Smith	202147	0	6
1	John Smith	202148	0	6
1	John Smith	202149	0	6
1	John Smith	202150	0	6
1	John Smith	202151	0	6
1	John Smith	202152	0	6
1	John Smith	202201	0	6

Forum Discussion

New table - list between two dates

Related content

Date Slicer not Responsive to Calculated Date Table

Creating Date Tables

Fact Table Multiple Dates Relationship with Dimension Date

Location Date tables not refreshing

Date Table?