I thought it might be as simple as creating a calculation similar to "if measure name = X then 'MTD'....etc" but that did not seem to be possible?
Attached is a workbook using superstore data. When using calculated fields that figure out MTD and YTD logic, is there then a way to include a grouping above it?
The real world came from needing to use limited real estate, so on the dashboard a scrollbar exists. So if we plant text objects on the dashboard that say "MTD", "YTD", they do not move with the scroll of the actual visual.
Without manipulating the underlying data to create more dimensions for those headers (pivoting columns to row), it would not be super easy. Of course, on a dashboard you can get away with things like this but it won't be dynamic based on the # of measures in the group: