Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Need help with data modelling

Hi friends,    Another problem:  I have a service contract with 3 types of calls (Normal, Urgent, Very Urgent) Furthermore, each call has 5 different 'stages' and depending on the call priority t...
Need Help
Tips and Tricks
zoloturu's avatar
zoloturu
Icon for Memorable Member rankMemorable Member
6 years ago

Hi Anonymous ,

 

Please provide how your initial data is look like.

And of course, I'm sure for 99% that all transformations from Excel can be done at PowerQuery inside of Power BI.


Regards,
Ruslan Zolotukhin (zoloturu)
BI Engineer at Akvelon Inc. / Kharkiv Power BI User Group Leader / DAX & Power BI Trainer
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!
It was useful? Press Thumbs Up!

You are from Ukraine? If yes then welcome to Power BI User Group - KhPUG website. Other country? Check and find proper one - Power BI User Groups

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hello Ruslan,

     

    Below you find an example of the dataset without any formatting. Is this enough info for you? 

     

    Kind regards, Sander

     

    Call number

     
    		PriorityAcceptation timeResponse timeSecure timeRestore timeResolve time
    Call 1Urgent01:19:2101:19:2113:59:0513:59:0513:59:05

    Call 2

    		Very Urgent00:16:0801:07:4907:13:1807:13:1807:13:18
    Call 3Normal00:09:13 18:51:3322:03:2222:03:2222:03:22

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Anonymous ,

      I'd like to suggest you use 'unpivot column' on your time fields to convert them to attribute and value, then you can simply use visual level filter to control what type of DateTime display on your visual.

      Unpivot columns (Power Query) 

      Regards,

      Xiaoxin Sheng