PowerBI DAX CONCATENATEX

Power BI DAX to concatenate distinct child item in a group

CASE Scenario

We have sales data for given set of products with remarks as shown below and we need the Remarks added comma separated.
  • ·        Open Power BI and Connect to the excel source which contains the Sales Data
  • ·        Once we import the data we create a measure using the DAX ,Consolidated Remarks = CONCATENATEX(VALUES(Sheet1[Remarks]),Sheet1[Remarks],",")
  •  Now we add the columns ProductName, Sales Amt (Aggregation SUM), Consolidated Remarks as shown below.






at

2 comments:

Subscribe to: Post Comments (Atom)

T-SQL LEAD LAG and SUM function based query

  Query on T-SQL window clause Below is the sales table Order_Date Name Product SubCategory ...

  • DataZen Syllabus
    INTRODUCTION TO DATAZEN PRODUCT ELEMENTS ARCHITECTURE DATAZEN ENTERPRISE SERVER INTRODUCTION SERVER ARCHITECTURE INSTALLATION SEC...
  • PowerBI Interview Questions and Answers
    Power BI Interview Questions – General Questions 1). What is self-service business intelligence? Ans: Self-Service Business Intelligenc...
  • MS BI Syllabus
    Microsoft Business Intelligence Course Syllabus SSRS – SQL Server Reporting Services  Getting Started 1. Understanding Reportin...