Forum Discussion
azaterol
Helper V
Helper VMatrix measure als column in Table
Hey there, is it possible to make this DAX: First date-sale = CALCULATE(FIRSTNONBLANK('Date'[Date],[Sales])) as a column in a table? I think maybe it is possible with power query, but i didin...
Hi azaterol
You can right-click on the table name on the fields pane and select "New Column"
Or in the data view select the table you want to add a column to, at the top ribbon under 'column tools' select 'new column'
amitchandak
Super User
Super Userazaterol ,
I think like
First date-sale = Sumx(Filter(Table, Table[Date] = Min('Date'[Date]) ), Table [Sales])