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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
rusty19
Regular Visitor

Adding minutes to time in PowerBI

Hello,

I am trying to create a meeting agenda in PowerBI and I have everything working but one thing – time!

 

In my table I have the duration in minutes that an item will have on the agenda.  What I wanted to show is if a meeting started at 1:30 for example, at what time should we be starting the next item for discussion (this is good to see if we are falling behind or ahead of schedule).

 

Example:

 

Start of meeting 1:30

 

ITEM                   Duration             TIME

Item 1                 5 min                   1:30 – 1:35

Item 2                 15 min                1:35 – 1:50

Item 3                 10 min                1:50 – 2:00

Item 4                 10 min                2:00 – 2:10

Item 5                 15 min                2:10 – 2:25

Item 6                 5 min                   2:25 – 2:30

 

Total time           60 min

1 ACCEPTED SOLUTION
Ahmedx
Super User
Super User

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Screenshot_3.png

Screenshot_2.png

View solution in original post

6 REPLIES 6
Ahmedx
Super User
Super User

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Screenshot_3.png

Screenshot_2.png

Hello, thank you for the quick response, but not working.  First of all, I can't seem to find the "New Calculation" function, so I tried it as a measure, but them got an error message:

 

RUNNINGSUM can only be used in the expression of a visual calculation.

 

My guess is that I did something wrong?

you must enable it in the settings

Screenshot_2.png

OMG IT WORKED - I am so grateful for the answer and EASY to follow instructions!!!

Greg_Deckler
Super User
Super User

@rusty19 Try:

End Column = [Start] + [Duration]/24/60

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Thank you - I saw your answer, but being a bit of a beginner, I don't understand it and not sure how to use it.  May I have more details please?

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors