Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi Folks,
I have tried to fix the out of present range problem in Power Bi Dax formula General background I have a data-set as below,
Link : Image Link
the dashboard allows user to select the preferred currency and then the table update the value. For example , if click on US, then the table sum all Sales in Jan from US as well
as showing $ or € accordingly
The DAX function i have tried is
CONCATENATE( Table[Country]="US", "$",FORMAT(sum(Table[Sales]),"0") but it comes up with below
Link : Image Link
Any help please. thanks
Solved! Go to Solution.
Hi @Peter_Price,
Obviously, you are wrong with CONCATENATE function, it not support there merge values which you wired.
Reference links:
Joins two text strings into one text string.
CONCATENATE(<text1>, <text2>)
You can use below measure to achieve your requirement:
Measure = VAR currCounty = SELECTEDVALUE ( Table[Country] ) VAR _symbol = SWITCH ( currCounty, "US", "$", "EUR", "€", "UK", "£", "$" ) RETURN _symbol & CALCULATE ( SUM ( Table[Sales] ), VALUES ( Table[Country] ) )
Regards,
Xiaoxin Sheng
Hi @Peter_Price,
Obviously, you are wrong with CONCATENATE function, it not support there merge values which you wired.
Reference links:
Joins two text strings into one text string.
CONCATENATE(<text1>, <text2>)
You can use below measure to achieve your requirement:
Measure = VAR currCounty = SELECTEDVALUE ( Table[Country] ) VAR _symbol = SWITCH ( currCounty, "US", "$", "EUR", "€", "UK", "£", "$" ) RETURN _symbol & CALCULATE ( SUM ( Table[Sales] ), VALUES ( Table[Country] ) )
Regards,
Xiaoxin Sheng
it works perfectly, thx XiaoXin
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
141 | |
79 | |
64 | |
52 | |
47 |
User | Count |
---|---|
212 | |
89 | |
76 | |
66 | |
60 |