Group on just one level

[Anonymous]

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

[PattemManohar]

@Anonymous Please use Matrix as below

[Anonymous]

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

[PattemManohar]

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

[Anonymous]

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

[v-frfei-msft]

Hi @Anonymous,

Is the excepted result you need?

Regards,

Frank

[Anonymous]

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

[Anonymous]

In SSRS I would just do