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...
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.

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