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't know how to make the input.
Thank you for help
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'
2 Replies
- James-Harpin
Resolver IV
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
azaterol ,
I think like
First date-sale = Sumx(Filter(Table, Table[Date] = Min('Date'[Date]) ), Table [Sales])
