Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I created a matrix. I am trying to create a variable dax formula to do the following:
1.For Each pair, identify the largest of the two and return the Net of the two amounts. (the red rectangle represents a pair with a common number "2110", then 2210 is another pair BUT then 2310 is not a pair).
2.For the smallest amount,,,retun "zero" or blank
3.If there are no pairs (for example 2310) , then return the existed amount that in the column "Amt doc Curr (AP)"
Solved! Go to Solution.
Hi @bgonen7 ,
Please refer to the sample file.
Highlighting the minimum and maximum values in a Power BI matrix
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
There are three DAX formulas for this solution and I hope someone can help me make these DAX formulas more effeicient:
Formula1:
To sum each line of each pair:
There are three DAX formulas for this solution and I hope someone can help me make these DAX formulas more effeicient:
Formula1:
To sum each line of each pair:
Hi @bgonen7 ,
Please refer to the sample file.
Highlighting the minimum and maximum values in a Power BI matrix
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |