Forum Discussion

kleighton's avatar
kleighton
Helper II
4 years ago

Table Column headers based on measure

Hi

 

I have the following table showing current stock balance and the forceasts and balances over the next 3 months.

I would like to change the column headers to use the dynamic Month name instead of +1, +2,+3 etc. For example, i could use a measure to return the desired name.

TMN+2 = (Format(EOMONTH(TODAY(),+2),"MMM"))&" " & "Bal."
 

 

Is there any way to use dynamic values or measures as column header values??

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    kleighton , You can have measures like

     

    next 3 and last 3  =
    var _max = eomonth( today() ,3)
    var _min = date(year(_max), month(_max)-6,1)
    return
    CALCULATE(SUM(Sales[Sales Amount]),filter(date, date[date] <=_max && date[date] >=_min))

    • kleighton's avatar
      kleighton
      Helper II
      4 years ago

      HI, thanks for your reply!

       

      My main question is regarding the table column names, how can i change them to show the dynamic month name? or is it even possible?