Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello
I hope you are very good, I have this problem for a while and I do not know how to start, I have these 3 tables which I need to do some operations to give me some indicators, from the T9 table is where more data are taken and for me is the Facts table, I need to take the MC data from the T13 table and relate it to the T9 table, the data of the table T13 that I need is the one that is filtered by period and year, it will only bring me that data, of the T9 I have the filters of; company name, market, year and period.
the idea is something like in the following visualization image that I already have an idea of how to look, but the MC column of the T13 does not filter because it is from another table and I can not relate it because I do not have a unique identifier I was thinking with a calendar table that makes me an intermediary:
I have other questions:
If after relating it I can operate formulas in dax of t13 and t9 and the current filters would take them?
How can I convert the period that is in whole number to month and date format?
Can the array visual I'm using to see filters and filtered data place that data in rows and not columns?
Thanks in advance
Hi @Syndicate_Admin ,
If after relating it I can operate formulas in dax of t13 and t9 and the current filters would take them?
Yes, please create relationship between them and set the filter direction to both.
How can I convert the period that is in whole number to month and date format?
Whole number to month and date format please use dax DATE(<year>, <month>, <day>)
DATE function (DAX) - DAX | Microsoft Learn
Can the array visual I'm using to see filters and filtered data place that data in rows and not columns?
Not quite sure what you mean, just swap the row and column fields of it.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |