Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
DanduMani104
Helper III
Helper III

DAX Function

Thank you for the help.But when compare to current week count with last week count,It is showing like this

DanduMani104_0-1703672812043.png

 

But I want to repesent it like current week and last week and variation in Totals only.How can I do that like below one

 

DanduMani104_1-1703672851699.png

 

please help

 

2 REPLIES 2
Fowmy
Super User
Super User

@DanduMani104 

You can not add additional column to your matrix as the measures added in the value section will prepresent under each column. One approach is to use Calculation Group. 

Sharing a dummy Power BI file representing your scenario would be beneficial. You can save the Power BI file on Google Drive or any other cloud storage platform and provide the link here. Kindly ensure that permission is granted to open the file.

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Sorry I donot have any dummy file in my Machine..U can send the Screenshots ,I will follow that

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.