Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All
I have below expression :-
What i want is AR_AMT_ X _rate= AR_AMT_SGD
https://www.dropbox.com/s/cgzsp911xj3sr1v/Testing3.pbix?dl=0
above is my PBI file.
Paul
Solved! Go to Solution.
@Paulyeo11
Try one of the following, not sure if you need to multiply or divide:
AR_AMT_SGD = [AR_AMT_] * [_rate]
AR_AMT_SGD = DIVIDE([AR_AMT_] , [_rate],BLANK() )
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Paulyeo11
Try one of the following, not sure if you need to multiply or divide:
AR_AMT_SGD = [AR_AMT_] * [_rate]
AR_AMT_SGD = DIVIDE([AR_AMT_] , [_rate],BLANK() )
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi @Paulyeo11 ,
If you want AR_AMT * _Rate, then shouldn't the formula be:
User | Count |
---|---|
97 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |