Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

DAX Function

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

 

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

 

 

please help

 

2 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    2 years ago

    Anonymous 

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

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