The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello everyone, I have 2 table below :
Table 1 :
Table 2 :
I post a plib in that link :https://drive.google.com/file/d/1i_KvhMvTM1HVo95eszcauvlLFLG2FRj2/view?usp=sharing
How can I add the provinces in table 2 (Campus Code is Unspecified) respectively to table 1 (as same as Province Name) ? Can everyone help me a dax ?
Table 1 like :
Simple enough, use TREATAS() to create virtual relationship on the fly if the perfomance is not a big concern.
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Paste well-prepared mock-up data first.
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Hi @CNENFRNL ,
I fix this pibx link: https://drive.google.com/file/d/1v5l0TgW5xPf0o5IqxBqPHSJ59jM-fP-8/view?usp=share_link
Sorry for inconvenience. Thank you
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Hi @CNENFRNL ,
I want to Sum value from table 2 into table 1 and don't show the row Unspecified .
Example :
Hi @CNENFRNL ,
I don't know how to use TREATAS , can you see the pibx I attached and help me
@sakuragihana , You need to create common dimensions like Province Name, date tec
Hi @amitchandak ,
I want to sum value from Table 2 that Campus Code is unspecified into Table 1 (respectively Province Name ) . I don't want to show Unspecified in the table 1
Table 1 like as :
Can you help me a dax ?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
95 | |
84 | |
66 | |
61 |
User | Count |
---|---|
246 | |
124 | |
115 | |
79 | |
78 |