March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
hi everyone , new to PQ in powerBI , i keep on getting this error , Expression.SyntaxError: Token ')' expected
this is my custom column - = Table.TransformColumns(#"Grouped Rows",("First Transaction Month",Date.StartOfMonth,Date.Type)
would appreciate any insights on this, as I am stuck here, I am doing a sample customer cohort & retention analysis
Hi, it is all about the second argument, you should provide it in a list. IF you are going to transform values on a column, you just need to use one List sign, but to change the values on more than a column, you have to provided a list including one sub list for each column, so revise your formula to=>
Transform a column = Table.TransformColumns(#"Grouped Rows",{"First Transaction Month",Date.StartOfMonth,Date.Type})
Transform two column= Table.TransformColumns(#"Grouped Rows",{{"First Transaction Month",Date.StartOfMonth,Date.Type},{"Name column 2}, each _+1})
Table.TransformColumns(#"Grouped Rows",{"First Transaction Month", Date.StartOfMonth,Date.Type})
or
Table.TransformColumns(#"Grouped Rows",{{"First Transaction Month", Date.StartOfMonth,Date.Type}})
For a single conversion, you can use either {} or {{}}
Try
able.TransformColumns(#"Grouped Rows",{{"First Transaction Month",Date.StartOfMonth, type date}})
--Nate