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.
Hello. I have a table created using addcolumns that have a dates columns and a measure. I would like to add a category column that respond to a column for some dimension.
I tried
Table1 = addcolumns(values('Fact_table'[dates]), "name1", measure, "name2", treatas({"category_name"}, 'Dim_Table'[Category])
but the Table1 isn´t filteres by Dim_Table'[Category] in the report.
please your asitance.
Hi ,
Try:
Table1 = addcolumns(values('Fact_table'[dates]), "name1", measure, "name2", CALCULATE(VALUES(XXXX),treatas({"category_name"}, 'Dim_Table'[Category]))
If the problem persists, please provide the results you expect based on your sample data
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Lenastray , In case fact has join with category
summarize('Fact_table', 'Fact_table'[Dates], 'Dim_Table'[Category],, "name1", [measure])
.
Thanks amitchandak, but fact hasn´t a relationshipt with category.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |