Forum Discussion
Dynamically change measure header name based on criteria
Okay I have a potential different route based on current DAX.
so I have a measure that calculates an amount with some filters. Within this measure, can I tell it to change the header name to the appropriate month? I have a column in my calendar table called "MonthName" that displays the months name.
(this measure calculates an amount based on other parameters to put within 30/60/90 day buckets)
_Grouped Amount = CALCULATE([_Open Amount],FILTER('RM20101 - Receivables',COUNTROWS(FILTER('Aged Groups',[_#Days] >='Aged Groups'[Min] && [_#Days] <= 'Aged Groups'[Max]))))
Super UserHi Anonymous ,
It's possible I'm misunderstanding your meaning a bit here, but you don't need to 'tell' anything to change headers.
The whole point of having a related calendar table is that you can use fields from the calendar table in visuals, and Power BI's context filtering will automatically select the correct headers based on the values available from the measure. The only control you need to exert is limiting the quantity of values displayed which, in your scenario, the relative month visual filter will achieve.
Pete