Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
HolgerS
Frequent Visitor

Transfer tble with time periods

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:

table PBI.JPG

Thanks.

Holger

 

1 ACCEPTED SOLUTION
6 REPLIES 6
Anonymous
Not applicable

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.

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

Holger

Anonymous
Not applicable

Use Power Query.

Best
D.

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

Anonymous
Not applicable

Perfect, thank you.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors