Helped need with calculating working hour and hour rate from date point and price per line.

[kjpackshootdk]

Hey

I have this table:

Where I want to calculate to show in a graphs how much each fotograf/user makes per hour.

I only have when each line in the table is entered and no total hours per day. So I have to figure out a way to calculate how long each user have been here that day from the change_date in this table.

Is there anyone how have an idea on how this could be done ?

Thank you so much in advance!

[RobbeVL]

Hi There,

Seems like you will need to use Datediff between the max and min values.

Measure= DATEDIFF(MAX(Date),MIN(Date),MINUTE)

This wil give you the amount of minutes she was there.

Hope this helps?

Robbe

[kjpackshootdk]

Thanks for your help RobbeVL

I did think about doing it that way, but then it would only work for one user and one day. I need it to work for all of the users and all of the days.

[RobbeVL]

Hi,

Just grab a visual and  slice it on that dimension.

ex. a matrix

Put users to columns & date to rows --> measure will be your value.

[kjpackshootdk]

I am way to new to Power BI, to understand where to start on this.

Can you help me on my way ?

[RobbeVL]

I just did!

Choose a Matrix visual.

Put the measure to values

date to rows

name to column

This will give you your result I hope

[kjpackshootdk]

Thanks!

I understood that and it seems to work. But for some reason all the values are negative, but that is easy to fix.

It also seems like the total in the matrix is way off from what the total of the rows really is. But i don't need the total.

How do I then use this date in a graph, so it is easier to read ?

[RobbeVL]

Hi,

Could you copy a sample dataset here?
Ill create some example visuals for you

[kjpackshootdk]

That would be so awesome, thanks a lot

order_id

client

change_date

fotograf

style_1

style_2

style_3

style_4

type

code

product

comment

price

361

Smaahjerter.dk

04/04/2013 19.52

Fotograf Kasper Blomgren J√∏rgensen

5,70447E+24

2013 SS Mini a Ture Lenius Pants

2d

17

361

Smaahjerter.dk

04/04/2013 19.52

Fotograf Kasper Blomgren J√∏rgensen

5,70447E+24

2013 SS Mini a Ture Gerry Speedos

17

361

Smaahjerter.dk

04/04/2013 19.52

Fotograf Kasper Blomgren J√∏rgensen

5,70447E+24

2013 SS Mini a Ture Hercules Shorts

17

361

Smaahjerter.dk

04/04/2013 19.52

Fotograf Kasper Blomgren J√∏rgensen

5,70447E+24

2013 SS Mini a Ture Ketil Shirt

17

361

Smaahjerter.dk

04/04/2013 19.52

Fotograf Kasper Blomgren J√∏rgensen

5,70447E+24

2013 SS Mini a Ture Lenius Pants

17

361

Smaahjerter.dk

04/04/2013 19.52

Fotograf Kasper Blomgren J√∏rgensen

5,70447E+24

2013 SS Mini a Ture Bibo Romper

17

361

Smaahjerter.dk

04/04/2013 19.52

Fotograf Kasper Blomgren J√∏rgensen

5,70447E+24

2013 SS Mini a Ture Marico Romper

17

361

Smaahjerter.dk

04/04/2013 19.52

Fotograf Kasper Blomgren J√∏rgensen

5,70447E+24

2013 SS Mini a Ture Marnis Romper

17

361

Smaahjerter.dk

04/04/2013 19.52

Fotograf Kasper Blomgren J√∏rgensen

5,70447E+24

2013 SS Mini a Ture Olisa Hat

17

361

Smaahjerter.dk

04/04/2013 19.52

Fotograf Kasper Blomgren J√∏rgensen

5,70447E+24

2013 SS Mini a Ture Lei dress

17

361

Smaahjerter.dk

04/04/2013 19.52

Fotograf Kasper Blomgren J√∏rgensen

5,70447E+24

2013 SS Mini a Ture Lala Dress

17

361

Smaahjerter.dk

04/04/2013 19.52

Fotograf Kasper Blomgren J√∏rgensen

5,70447E+24

2013 SS Mini a Ture Helle Swimsuit

17

361

Smaahjerter.dk

04/04/2013 19.52

Fotograf Kasper Blomgren J√∏rgensen

5,70447E+24

2013 SS Mini a Ture Annilie Romper

17

361

Smaahjerter.dk

04/04/2013 19.52

Fotograf Kasper Blomgren J√∏rgensen

5,70447E+24

2013 SS Mini a Ture Edina Body/Dress

17

361

Smaahjerter.dk

04/04/2013 19.52

Fotograf Kasper Blomgren J√∏rgensen

5,70447E+24

2013 SS Mini a Ture Elmie Body

17

361

Smaahjerter.dk

04/04/2013 19.52

Fotograf Kasper Blomgren J√∏rgensen

5,70447E+24

2013 SS Mini a Ture

17

361

Smaahjerter.dk

04/04/2013 19.52

Fotograf Kasper Blomgren J√∏rgensen

5,70447E+24

2013 SS Mini a Ture Loi T-shirt

17

357

Smaahjerter.dk

04/04/2013 19.54

Fotograf Kasper Blomgren J√∏rgensen

5,71091E+24

2013 SS Petit by Sofie Schnoor P131301-Rose

17

357

Smaahjerter.dk

04/04/2013 19.54

Fotograf Kasper Blomgren J√∏rgensen

5,71091E+24

2013 SS Petit by Sofie Schnoor P131211-D.Rose

17

357

Smaahjerter.dk

04/04/2013 19.54

Fotograf Kasper Blomgren J√∏rgensen

5,71091E+24

2013 SS Petit by Sofie Schnoor P131201-D.Rose

17

357

Smaahjerter.dk

04/04/2013 19.54

Fotograf Kasper Blomgren J√∏rgensen

5,71091E+24

2013 SS Petit by Sofie Schnoor P131212-Blk

17

357

Smaahjerter.dk

04/04/2013 19.54

Fotograf Kasper Blomgren J√∏rgensen

3,66193E+24

2013 SS Zadig   Voltaire sweatshirt

17

357

Smaahjerter.dk

04/04/2013 19.54

Fotograf Kasper Blomgren J√∏rgensen

3,66193E+24

2013 SS Zadig   Voltaire kjole

17

357

Smaahjerter.dk

04/04/2013 19.54

Fotograf Kasper Blomgren J√∏rgensen

3,66193E+24

2013 SS Zadig   Voltaire jakke

17

357

Smaahjerter.dk

04/04/2013 19.54

Fotograf Kasper Blomgren J√∏rgensen

3,66193E+24

2013 SS Zadig   Voltaire

17

357

Smaahjerter.dk

04/04/2013 19.54

Fotograf Kasper Blomgren J√∏rgensen

3,66193E+24

2013 SS Zadig   Voltaire

17

357

Smaahjerter.dk

04/04/2013 19.54

Fotograf Kasper Blomgren J√∏rgensen

3,66193E+24

2013 SS Zadig   Voltaire

17

357

Smaahjerter.dk

04/04/2013 19.54

Fotograf Kasper Blomgren J√∏rgensen

3,66193E+24

2013 SS Zadig   Voltaire kjole

17

357

Smaahjerter.dk

04/04/2013 19.54

Fotograf Kasper Blomgren J√∏rgensen

3,66193E+24

2013 SS Zadig   Voltaire navy strik kjole med hvide stjerner

17

357

Smaahjerter.dk

04/04/2013 19.54

Fotograf Kasper Blomgren J√∏rgensen

3,66193E+24

2013 SS Zadig   Voltaire mÊlkestribet nederdel med pink ZV broderet

17

357

Smaahjerter.dk

04/04/2013 19.54

Fotograf Kasper Blomgren J√∏rgensen

3,66193E+24

2013 SS Zadig   Voltaire jakke

17

357

Smaahjerter.dk

04/04/2013 19.54

Fotograf Kasper Blomgren J√∏rgensen

3,66193E+24

2013 SS Zadig   Voltaire t-shirt

17

360

Smaahjerter.dk

04/04/2013 19.56

Fotograf Kasper Blomgren J√∏rgensen

2,849E+25

2013 SS Yporque Chooper

2d

17

360

Smaahjerter.dk

04/04/2013 19.56

Fotograf Kasper Blomgren J√∏rgensen

2,8488E+25

2013 SS Yporque Hero

17

360

Smaahjerter.dk

04/04/2013 19.56

Fotograf Kasper Blomgren J√∏rgensen

2,8485E+25

2013 SS Yporque Chino

17

360

Smaahjerter.dk

04/04/2013 19.56

Fotograf Kasper Blomgren J√∏rgensen

2,8484E+25

2013 SS Yporque Dino

17

360

Smaahjerter.dk

04/04/2013 19.56

Fotograf Kasper Blomgren J√∏rgensen

2,8481E+25

2013 SS Yporque Sheriff

17

360

Smaahjerter.dk

04/04/2013 19.56

Fotograf Kasper Blomgren J√∏rgensen

2,8479E+25

2013 SS Yporque Electric

17

360

Smaahjerter.dk

04/04/2013 19.56

Fotograf Kasper Blomgren J√∏rgensen

2,8478E+25

2013 SS Yporque Aicraft

17

360

Smaahjerter.dk

04/04/2013 19.56

Fotograf Kasper Blomgren J√∏rgensen

2,8474E+25

2013 SS Yporque Dinosaur

17

[RobbeVL]

Hi There,

I hope this in my example file helps you:
https://drive.google.com/file/d/1hTDBZoKcLJsZCU5s0xAK61ofvRktV9WQ/view?usp=sharing