Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register 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