Forum Discussion

NJ81858's avatar
NJ81858
Helper IV
4 years ago
Solved

Grouping Table By One Column

I am creating this table, in which every column is based on the Company Name. For some reason all of my other columns are showing the same values throughout the table. I just want to have each column to populate based on the Company Name for each particular row.

Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi， NJ81858 

    Your new grouping table doesn't apear to have a relationship with table 'ACH Trans-INITATED' (based on field 'CompanyName') .

    Please try formula like:

    Date =
CALCULATE (
    LASTDATE ( 'ACH Trans-INITATED'[Batch Date Initiated] ),
    FILTER (
        'ACH Trans-INITATED',
        'Grouping Table'[Company Name] = 'ACH Trans-INITATED'[Company Name]
    )
)

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi

     

    Try put all your formulas in a CALCULATE Function also, you should remove all the filters exept the company name, something like this:

     

     

    Average Days = 
CALCULATE(
    AVERAGE(your_table[your_column]),
    ALLEXCEPT(your_table,your_table[Company Name]))

     

     

    Kind regards,
    José
    Please mark this answer as the solution if it resolves your issue.
    Appreciate your kudos! 🙂

    • NJ81858's avatar
      NJ81858
      Helper IV
      4 years ago

      I changed the way that the date is calculated to be this and it still shows up as the same for each company name.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Coult you share you PBI file so that we can take a look? If you want you can DM me