Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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...
Need Help
PattemManohar's avatar
PattemManohar
Community Champion
7 years ago

Anonymous Please use Matrix as below

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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's avatar
    PattemManohar
    Community Champion
    7 years ago

    Anonymous Please provide the sample data to replicate your issue.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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's avatar
        v-frfei-msft
        Community Support
        7 years ago

        Hi Anonymous,

         

        Is the excepted result you need?

         

         

        Regards,

        Frank