Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello Community.
I have the following problem
I need to show the Minimum and the Maximo of Capital, Interest and Interest Mora, for each Month and for Each Year shown in the Matrix.
But I haven't found the calculation, as you can see the values I show by Dodne Range I'm clearly miscal calculating the data.
How should it be the right formula?
Solved! Go to Solution.
@Syndicate_Admin , Try like
calculate(maxx(values(Table[Mes NOs]), [Captial]), allexcept(Table, Table[year]))
Here's what it should be:
@Syndicate_Admin , Try like
calculate(maxx(values(Table[Mes NOs]), [Captial]), allexcept(Table, Table[year]))
Hello, it almost works for me, gives me the maximum of registration and on this occasion I look for the maximum of the stretch.
User | Count |
---|---|
95 | |
86 | |
78 | |
72 | |
66 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |