Good morning, I write to see if the behavior I am seeing since the last update is an error that will be fixed or is a change in the behavior of the summarizecolumns function when used in DirectQuery. The version of the PwBi destop is Version: 2.110.805.0 64-bit (October 2022)
I have a data set published with the sales of the company, this rests in a single table, from the destop I connect via direct query to this published set and build a summary table converting the new dataset into a composite model. I do the summary with summarizecolumns as follows:
Summary table =
calculatetable(
SUMMARIZECOLUMNS(
'Ventas_Publicadas'[Cod_Cliente];
'Ventas_Publicadas'[Date];
"Sales"; [Net Sale ($)]);
'Ventas_Publicadas'[Date]>=20221001;
'Ventas_Publicadas'[Date]<20221101)
This table brought me the sales per customer grouped by day (eliminating the granularity of product), however now in the column "Sales" does not bring me the value of sales, instead I epite the value of the date.
Check the logisca of this summary table, in a dataset with sales in import mode, and if it works correctly. So I presume that the last update changed the logic of the behavior of the summaricecolumns function to tables via direct query.
Please your help in case you have information related to this.
Thanks a lot!
