CFA And Chartered Financial Analyst Are Registered Trademarks Owned By CFA Institute. Go to Data view, click on New table Power bi union two columns Then we w 4: expression It is a token of appreciation! Conclusion. If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. I then was able to drag the fields into a table and select Latest for the date column and sum for the SalesQty column in Power BI on the Fields pane of the table visual. Hi @naaatthh,. Thanks for help. Name your new column Top performer product. Attend online or watch the recordings of this Power BI specific conference, which includes 130+ sessions, 130+ speakers, product managers, MVPs, and experts. Find out more about the February 2023 update. Providing Financial Modelling, Strategic Data Modelling, Model Auditing, Planning & Strategy and Training Courses. Try to have Jahr and Monat as real columns in the Date table and use them in the table visual and in the SUMMARIZE . You can use SUMMARIZE in the innermost group, but you have to use GROUPBY in order to access to columns calculated in an inner grouping . For example, you may have multiple city sales values. Product Category AlternateKey. I've tried using the SUMMARIZE function but can't seem to get it to work? The same post and linked articles to it point out that one should not calculate values directly with SUMMARIZE especially due to its handling of filters in the measures used inside the SUMMARIZE calculations. The SUMMARIZE function uses the following syntax to operate: SUMMARIZE(