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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Transformed table with new rows

Good day everyone.
I need to make transformed table using data from next table: 

IDLE_IDSTART_DTSTART_TIMEEND_DTEND_TIMEIDLE_TYPE
12285109.09.201905:57:0001.10.201909:00:00Planned
12311101.10.201909:30:0002.10.201917:00:00Planned


I need to make visualization like this (abridged example):

IDLE_IDSTART_DTSTART_TIMEEND_DTEND_TIMEIDLE_TYPE
12285109.09.201905:57:0009.09.201924:00:00Planned
12285110.09.201900:00:0010.09.201924:00:00Planned
12285111.09.201900:00:0011.09.201924:00:00Planned
12285112.09.201900:00:0012.09.201924:00:00Planned
12285113.09.201900:00:0013.09.201924:00:00Planned
12285114.09.201900:00:0014.09.201924:00:00Planned
12285115.09.201900:00:0015.09.201924:00:00Planned
12285125.09.201900:00:0025.09.201924:00:00Planned
12285126.09.201900:00:0026.09.201924:00:00Planned
12285127.09.201900:00:0027.09.201924:00:00Planned
12285128.09.201900:00:0028.09.201924:00:00Planned
12285129.09.201900:00:0029.09.201924:00:00Planned
12285130.09.201900:00:0030.09.201924:00:00Planned
12285101.10.201900:00:0001.10.201909:00:00Planned
12311101.10.201909:30:0001.10.201924:00:00Planned
12311102.10.201900:00:0002.10.201917:00:00Planned


I know, it looks really strange, but i need this visualization for easy count of idle for each day. Also first table was formed in DirectQuery, and i need not to change initial table.
Any suggestions come useful.
Best regards
Alexandr

2 REPLIES 2
amitchandak
Super User
Super User

@Anonymous , Not very clear. But refer if my blog can help

#POWERBI: How to divide/distribute values between start date or end date or count days across months/days: https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-or-end-date/ba-p/1503785

Anonymous
Not applicable

 

 

 

This is link to .pbix example of data from my existing table

https://arcelormittal-my.sharepoint.com/:u:/g/personal/alexandrvpat_arcelormittal_com1/ETL8_ueG8zlMs... 

As you can see in .pbix file, i understood how to use your method, but main problem is that i can't use measure day for count of idle time.
Please check correctness of my actions in this file.
Best regards, Alexandr

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.