Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi,
I am using the below method:
Solved! Go to Solution.
It would be easier to tackle your case having a mocking example of your dataset.
Please check the attached file - maybe it is what you need.
Best Regards,
Alexander
Hi @lafakios,
You should leave only unique values first with the help of VALUES or DISTINCT and then concatenate them.
Like that:
In plain text:
AllDates = CONCATENATEX ( CALCULATETABLE ( VALUES ( Table1[YYYY-MM] ), Table1[Date] < DATE ( 2014, 1, 1 ) ), Table1[YYYY-MM], ", " )
Best Regards,
Alexander
The above suggestion cannot unfortunately be used in this case.
The item is a kind of key (which is not unique at Table1 but is unique at Table2).
The item is found in Table 1 several times with a different value of YYYY-MM.
In Table2 which has only the distinct values of the items, for each item I would like to have in an column a summary of all YYYY-MM values that are present at the various entries of that item in Table1.
Please note that the YYYY-MM values are handled as text in both tables.
That's why I am using the expression: Table1[Item] = Table2[Item]
It would be easier to tackle your case having a mocking example of your dataset.
Please check the attached file - maybe it is what you need.
Best Regards,
Alexander
Hi,
This did deliver the wanted result, thank you a lot for your help!
I am also providing below the suggested formula of the solution:
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
9 | |
8 | |
8 | |
7 |
User | Count |
---|---|
14 | |
12 | |
11 | |
10 | |
8 |