Forum Discussion

haefnja's avatar
haefnja
Frequent Visitor
5 years ago
Solved

New grouping column

I am looking to add a grouping column that looks at the values in a few different columns to determine the value that should be entered.  My data is from a production table that records the good prod...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    This calculated column formula works

    =CALCULATE(MAX(Data[ProductDescription]),FILTER(Data,Data[ReferenceID]=EARLIER(Data[ReferenceID])&&Data[ProductType]="G"))

    Hope this helps.

  • selimovd's avatar
    selimovd
    5 years ago

    Hey haefnja ,

     

    DirectQuery is a big difference.

    The problem is not CALCULATE, the CALCULATE function works with DirectQuery. The problems are usually the limits for calculated tables and calculated columns.

     

    In your case add the column in your data source, from my point of view that's the best place to do that for your case.

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
haefnja's avatar
haefnja
Frequent Visitor
5 years ago

So update to close this out, I ended up having to make a few new tables.  first was a new calculated filtered table that just brings in the referenceID and product description for only product type of "G".  Then, I had to make another table that brings in the data from the main table, but import instead of direct query.  once it imports, I can use the lookup value for a new column that looks for the referenceID and returns the good product code.  probably a very round-about way to do it, but it's working so I am happy.  Thanks to selimovd and Ashish_Mathur for trying to help!