Forum Discussion
Is it feasible using a Column from Another Table as Slicer Without Relationship?
Calendar's date connected with Leadsort(date) in table 1 and leadreceiveddate(date) in table2 respectively.
Since both Table 1&2 do not have primary Key to let them connect each other.
Is there a way I can use a column called Type(text) from Table 2 in Table 1 as Slicer?
Anonymous you can use TREATAS function to achieve. TREATAS function - DAX | Microsoft Docs
✨ Follow us on LinkedIn
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
2 Replies
- parry2k
Super User
Anonymous you can use TREATAS function to achieve. TREATAS function - DAX | Microsoft Docs
✨ Follow us on LinkedIn
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡