get dates to show up as measures RRS feed

  • Question

  • Is it possible to get date values to show up as measures (to the right, rather than as a header)? 

    Wednesday, November 23, 2016 12:26 AM


  • Yes. Use the values function. As lon as values returns a single column, single row table, it can be returned as a measure. Something like this should work Date = firstdate(values(table[date]))

    Self Service BI Expert using Power Pivot http://exceleratorbi.com.au

    Wednesday, November 23, 2016 8:15 AM