Transfer tble with time periods

[HolgerS]

Hello,

How do I transform a spreadsheet that contains multi-monthly time periods so that I can evaluate them with a date hierarchy after months or days? For example, a table contains a From Date column and a To Date column. How can I discretize this data to make a daily analysis? The table I have looks like this:

Thanks.

Holger

[Anonymous]

Sie mussen expand each row into as many (consecutive) Tage as there are in the VON-BIS period and allocate all Ihre Zahlen accordingly. Then it's leicht: you just join your Daten table an die Tagen and you'll be able to author einfach(es?) DAX.

Best
D.

[HolgerS]

Thanks, but sorry, I can't follow you. How to expand each row in the table (which function can I use)? Thanks.

Holger

[Anonymous]

Use Power Query.

Best
D.

[HolgerS]

Yes, ok. Which function of PQ would you use for this task?

[Anonymous · Accepted solution]

OneDrive: How to expand date ranges into individual days in Power Query (M)

Best

D.

[HolgerS]

Perfect, thank you.