Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello
I need to add the values of the column ("Inscrits") of the table ("Annexa2")
But segun un filtro: tabla "Fam_Act", column "Type" = "Workshops"
---------
Table "Annexa2" and "Fam_Act" are related through the "Fami_Act_Centre2" field
Thanks a lot!!
Solved! Go to Solution.
@Syndicate_Admin ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
Hi @Syndicate_Admin ,
I think you want to calculate sum by Fami_Act_Centre2 and Type in "Fam_Act" table should equal to Workshops.
Try this code.
Column = sumx(filter(Annexa2,Annexa2[Fami_Act_Centre2]=EARLIER(Fam_Act[Fami_Act_Centre2])&& Fam_Act[Type] ="Workshops" ) ,Annexa2[Registered] )
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Syndicate_Admin ,
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file without sensitive data.
Best Regards,
Rico Zhou
Thanks a lot!!
Hi @Syndicate_Admin ,
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file without sensitive data.
Best Regards,
Rico Zhou
Excuse me... that I have not explained myself very well
I want to add the column "inscrits" of the first table, but only take into account the rows that in the related table "Fam_Act" put "Workshops"
Table "Annexa2"
Column 1 | Fami_Act_Centre2 | Registered |
AAA | 3 | |
BBB | 4 |
"Fam_Act" table
Type | Fami_Act_Centre2 |
Workshops | AAA |
Diffusion | BBB |
Hi @Syndicate_Admin ,
I think you want to calculate sum by Fami_Act_Centre2 and Type in "Fam_Act" table should equal to Workshops.
Try this code.
Column = sumx(filter(Annexa2,Annexa2[Fami_Act_Centre2]=EARLIER(Fam_Act[Fami_Act_Centre2])&& Fam_Act[Type] ="Workshops" ) ,Annexa2[Registered] )
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Syndicate_Admin a, new column in table 1
maxx(filter(Fam_Act, Fam_Act[Fami_Act_Centre2] = Annexa2[Fami_Act_Centre2] ) ,Fam_Act[Type] )
or
maxx(filter(Fam_Act, Fam_Act[Fami_Act_Centre2] = Annexa2[Fami_Act_Centre2] && Fam_Act[Type] ="Workshops" ) ,Fam_Act[Type] )
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
@Syndicate_Admin ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
112 | |
105 | |
94 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |