Summary
It is possible to create a table with time series between two dates in Power BI using the GENERATESERIES() function and a custom column between the two dates for each project.
1
Additionally, a disconnected date table with no relationships and a measure to calculate totals can be used to create a table between two dates.
2
Good design practices for creating date tables in data models using Power BI Desktop include using the Auto date/time option, connecting to a date dimension table, generating a date table, and using DAX to clone an existing date table.
3
According to
See more results on Neeva
Summaries from the best pages on the web
Summary
The user is trying to create a time series data set to serve as input for a line chart in DAX. They have tried using the GENERATESERIES() function, but are unable to loop over each project of the Projects table to produce a time series for each project in the same output table. The user is able to achieve this by adding a custom column between the two dates for each project, but due to performance, this needs to be computed in DAX.
Create a table with time series between two dates ... - Power BI
powerbi.com
Summary
This forum post provides a solution to a user who is having trouble creating a table between two dates in a spreadsheet in.xls. The solution involves creating a disconnected date table with no relationships, and adding a measure to calculate totals. The post also provides a reminder to add the measure first to avoid an error when adding the Name and Date fields first.
Create a table between two dates - Power BI
powerbi.com
Summary
This article provides good design practices for creating date tables in data models using Power BI Desktop. It explains how to use the Auto date/time option, connect to a date dimension table, generate a date table, and use DAX to clone an existing date table. It also provides tips on how to use the DAX time intelligence functions to filter, group, and drill down through calendar time periods.
Create date tables in Power BI Desktop - Power BI | Microsoft Docs
microsoft.com
