Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
Hello everyone,
I have two measures.
A sales measure and a sales percentage measure wich calculate the percentage change between April and May.
Sale 2022 April = Calculate(Document[Sale],DATESBETWEEN('Date'[Date],DATE(2022,4,1),DATE(2022,4,30)))Previous Month April - May =
VAR X = [Sale 2022 May] - [Sale 2022 April]
VAR Y = DIVIDE(X, [Sale 2022 April])
Return Y
Initial sitation:
| Sale 2022 May | Previous Month April - May | Sale 2022 April | ||
| $ 2000 | 50.0 % | $ 1000 |
Expected sitation:
Is it possible to display both in one measure. Here as an example:
| Sale 2022 May |
| 50.0 % $ 2000 |
Solved! Go to Solution.
Hi @azaterol ,
You can try something like this:
Measure = FORMAT([Previous Month April - May],"Percent")&" $"&[Sale 2022 May]
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.
Hi @azaterol ,
You can try something like this:
Measure = FORMAT([Previous Month April - May],"Percent")&" $"&[Sale 2022 May]
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.
hi @azaterol,
you can use a multi row card, through which you can put 2 measures in one card.
@UjjawalTyagi518 thats not what I look for. I use a matrix and still want use it.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.