Forum Discussion
Resolver IIs it possible to keep original number format when combing measures?
Good morning
I have use case where I have to show two types of information in one table.
In order to achieve this I combined two measures together. The first is in currencey format and the second in whole number format.
When I put the measure into a visual, I get the reults I need, but I would like to show the combined measure reult in the original format of both measures.
Is this possible using DAX Format for example? I have tried using it, but I get an error
Thanks
Hi PoweredOut ,
Based on your description, I have created a simple sample:
Please try:
Measure3 = var _a = [Measure1] var _b = [Measure2] return FORMAT(_a,"Currency")&" "&INT(_b)Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
FreemanZSuper User
hi PoweredOut
try to create two measures with same code, but different format.
v-jianboli-msftCommunity Support
Hi PoweredOut ,
Based on your description, I have created a simple sample:
Please try:
Measure3 = var _a = [Measure1] var _b = [Measure2] return FORMAT(_a,"Currency")&" "&INT(_b)Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.