Forum Discussion

N-msft's avatar
N-msft
Frequent Visitor
2 years ago

Use dynamic column names in calculation groups

Hi,   I am using calculation groups to show a matrix visual that contains measures on both axes, i.e., on rows & columns.      TodaysValue YesterdaysValue DayBeforeYesterdayvalue MTD for C...
Need Help
N-msft's avatar
N-msft
Frequent Visitor
2 years ago

Thanks Anonymous 

 

I am using multiple measures i.e. Total Sales, Total Profits, etc. on Rows of the matrix along with a calculation group with the following calculation items :

  • TodaysValue
  • YesterdaysValue
  • DayBeforeYesterdayvalue
  • MTD for Curr Month

I am stuck at naming these calculation Items dynamically like -

  • TodaysValue should be Today's date. 
  • YesterdaysValue should be yesterday's date
  • DayBeforeYesterdayvalue should be day before yesterday's date
  • MTD for Curr Month should be "Current Month's Name".

Hope I am able to explain it now..

 

Attached is the screesnhot as unable to upload .PBIX file.

ā€ƒ

 

foodd's avatar
foodd
Community Champion
2 years ago

Hello N-msft, remember to adhere to the decorum of the Community Forum when asking a question.

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523/highlight/true#M607150

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

 

If your requirement is solved, please make THIS ANSWER a SOLUTION āœ”ļø and help other users find the solution quickly. Please hit the LIKE šŸ‘ button if this comment helps you.  Proud to be a Super User!