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.
I have a table with 486 Franquicas, in each year or month there are different amounts of Franchises according to their date of entry, but when I want to make the sum per month or year, the table only shows me the total.
In my franchise talve each row equals a franchise, so I tried countrows and SUM. The result is always the same.
Solved! Go to Solution.
Hello! Thank you for your answers.
I realized that the problem was my calendar table. there was no right relationship. fixing this fixed the problem
Hi, @Syndicate_Admin
What does your current data model look like?
Did you add another calendar table?
Best Regards,
Community Support Team _ Eason
Hello! Thank you for your answers.
I realized that the problem was my calendar table. there was no right relationship. fixing this fixed the problem
@Syndicate_Admin , You need to share the formula
sumx(values('Date'[Year]), [Total Franquicias])
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 |
---|---|
96 | |
87 | |
84 | |
70 | |
69 |
User | Count |
---|---|
227 | |
127 | |
118 | |
82 | |
80 |