cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rbie Regular Visitor
Regular Visitor

Group on just one level

Just beginning with power bi and I seem to struggle with even the simplest of tasks :-)

 

I have the following table

 

Name      Datetime               FieldName NewValue OldValue

PersonA  22/01/2019 9:24      FIeldA         10             0

PersonA  23/01/2019 10:35    FIeldA         25            10

PersonA  23/01/2019 10:36    FIeldB         15            0

PersonB  21/01/2019 10:35    FIeldA         0            15

PersonB  22/01/2019 8:35      FIeldB         10            5 

 

I just  want something like in my report

 

Person A

          22/01/2019 9:24      FIeldA         10             0

          23/01/2019 10:35    FIeldA         25            10

          23/01/2019 10:36    FIeldB         15            0

Person B

          21/01/2019 10:35    FIeldA         0            15

         22/01/2019 8:35      FIeldB         10            5 

 

I tried it with a table and a matrix and I can't seem to do it

7 REPLIES 7
Super User
Super User

Re: Group on just one level

@Rbie Please use Matrix as below

 

image.png



Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !





Rbie Regular Visitor
Regular Visitor

Re: Group on just one level

Hi Pattem,

 

If I try that it gets the First() value of fieldname, newvalue,oldvalue so not the required result.

 

This wasn't clear in the example I gave but the combination username, fieldname, time is not unique

 

I basically want a detail table but with a grouping on username

Super User
Super User

Re: Group on just one level

@Rbie Please provide the sample data to replicate your issue.



Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !





Rbie Regular Visitor
Regular Visitor

Re: Group on just one level

USERNAME;FieldName;CREATEDDATETIME;NewValue;OldValue
USERA;GDTotalCostAmountMST;22/01/2019 14:48;520;0
USERA;GDTotalCostAmountMST;22/01/2019 14:44;81550;0
USERA;GDTotalCostAmountMST;22/01/2019 14:43;12250;0
USERA;GDTotalCostAmountMST;22/01/2019 14:43;804.48;0
USERA;GDTotalCostAmountMST;22/01/2019 14:42;43334.8;0
USERA;GDTotalCostAmountMST;22/01/2019 14:34;-43334.8;0
USERA;GDTotalCostAmountMST;22/01/2019 14:32;1600;0
USERA;GDTotalCostAmountMST;22/01/2019 14:32;280;0
USERA;GDTotalCostAmountMST;22/01/2019 14:32;39000;0
USERA;GDTotalCostAmountMST;22/01/2019 14:33;41.72;0
USERA;GDTotalCostAmountMST;22/01/2019 14:33;11000;0
USERA;GDTotalCostAmountMST;22/01/2019 14:33;2200;0
USERB;GDTotalCostAmountMST;22/01/2019 9:24;0;623
USERB;GDTotalCostAmountMST;22/01/2019 9:24;623;0
USERB;GDTotalCostAmountMST;22/01/2019 9:32;0;143.76
USERB;GDTotalCostAmountMST;22/01/2019 9:32;143.76;0
USERB;GDTotalCostAmountMST;22/01/2019 10:36;0;572.76
USERB;GDTotalCostAmountMST;22/01/2019 10:36;572.76;0

Community Support Team
Community Support Team

Re: Group on just one level

Hi @Rbie,

 

Is the excepted result you need?

 

Capture.PNG

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Rbie Regular Visitor
Regular Visitor

Re: Group on just one level

Sorry no, I don't want the old and new value summed/counted I just want them exactly as they appear in the data, but without the repeating username (it is just a layout thing)

so using my example

 

USERA

     GDTotalCostAmountMST  22/01/2019 14:48 520  0
     GDTotalCostAmountMST;22/01/2019 14:44;81550;0
     GDTotalCostAmountMST;22/01/2019 14:43;12250;0
     GDTotalCostAmountMST;22/01/2019 14:43;804.48;0
     GDTotalCostAmountMST;22/01/2019 14:42;43334.8;0
     GDTotalCostAmountMST;22/01/2019 14:34;-43334.8;0
     GDTotalCostAmountMST;22/01/2019 14:32;1600;0
     GDTotalCostAmountMST;22/01/2019 14:32;280;0
     GDTotalCostAmountMST;22/01/2019 14:32;39000;0
     GDTotalCostAmountMST;22/01/2019 14:33;41.72;0
     GDTotalCostAmountMST;22/01/2019 14:33;11000;0
     GDTotalCostAmountMST;22/01/2019 14:33;2200;0

USERB
     GDTotalCostAmountMST;22/01/2019 9:24;0;623
     GDTotalCostAmountMST;22/01/2019 9:24;623;0
     GDTotalCostAmountMST;22/01/2019 9:32;0;143.76
     GDTotalCostAmountMST;22/01/2019 9:32;143.76;0
     GDTotalCostAmountMST;22/01/2019 10:36;0;572.76
     GDTotalCostAmountMST;22/01/2019 10:36;572.76;0

Rbie Regular Visitor
Regular Visitor

Re: Group on just one level

In SSRS I would just do

 

 

ssrs.jpg