Forum Discussion
Transformed table with new rows
Good day everyone. I need to make transformed table using data from next table: IDLE_ID START_DT START_TIME END_DT END_TIME IDLE_TYPE 122851 09.09.2019 05:57:00 01.10.2019 09:00:00 ...
amitchandak
Super User
Super UserAnonymous , 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
This is link to .pbix example of data from my existing table
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