Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
NJ81858
Helper IV
Helper IV

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.

Pred Table.PNG

1 ACCEPTED SOLUTION

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.

View solution in original post

4 REPLIES 4
jcalheir
Solution Supplier
Solution Supplier

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! 🙂

Date.PNG

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

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.

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors