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.
Hi Community,
Thanks to my database, I get this result.
But I have to complete this matrix with new elements which are not present in the database, but which are obtained by a simple calculation. How can I get this result ?
I tried to create a table and one to many relationship, and use switch(TRUE()... Without success.
Solved! Go to Solution.
HI
You have to create 2 measure
Marge=[CA TTC]-[PRIX_REVIENT_TTC]
Marge%=divide(Marge,[CA TTC]
But first you do not seem to have already have lmeasure for CA TTC and Prix reveint TTC
CA TTC=sum([CA_TTC])
PR TTC=sum([PRIX REVEINT TTC]
HI
You have to create 2 measure
Marge=[CA TTC]-[PRIX_REVIENT_TTC]
Marge%=divide(Marge,[CA TTC]
But first you do not seem to have already have lmeasure for CA TTC and Prix reveint TTC
CA TTC=sum([CA_TTC])
PR TTC=sum([PRIX REVEINT TTC]
User | Count |
---|---|
85 | |
81 | |
67 | |
63 | |
54 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |