Forum Discussion
convert dax to power query
Hello all,
I've solved my problem in dax, but its become necessary for it to be implemmented in power query.
How can I write the following:
Start Date = CALCULATE ( MIN( 'table'[Date Made] ), ALLEXCEPT ( 'table', 'table'[some category]))
All it's doing is finding the missing values for the date something was made for a given category.
All the dates listed for a given category are the same, so calling the minimum isn't necessary but it is functionally accurate.
Any help would be much appreciated as I'm very new to Power Query.
Thanks!
3 Replies
=let a=Table.Buffer(Table.Group(Table,"Some Category",{"n",each List.Min([Date Made])})) in Table.AddColumn(Table,"MinDate",each a{[#"Some Category"=[Some Category]]}[n])
