Forum Discussion
Creating Buckets to add up the time between changes
My dataset has 3 columns that can look like this. STATUS CHANGEDATE WONUM ASSIGN 5/1/2023 WO-23521 IN PROGRESS 5/2/2023 WO-23521 SUBMITTED 5/10/2023 WO-23521 IN REVIEW 5/...
This is fantastic thank you. The issue I run into is it I am not sure of the correct way to update the source from
Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcgwO9nT3U9JRMtU31DcyMDIGMsP9dY2MTY0MlWJ1opU8/RQCgvzdg1yDg8GqjLCqCg518vUMCXF1gZhkgMuoINcwT9dwiCLs9gW5erk6ww0yJspNhibEOMocpkgBn6sssKtyDADaGAYzyhKLolgA"to my actual source which is a SQL database with a query to my dataset. I tried adding how I thought it would work but I get an agument error so I'm probably putting missing/inserting an extra ( or , somewhere
Source = Sql.Database("ogssqlbi03ptul", "public_rpt", [Query="select * from maximo.MAXIMO_OGSLOCUSWOSTATUS"], let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [STATUS = _t, CHANGEDATE = _t, WONUM = _t]),
Pull your data from DB through PQ and a source line will be generated. Just paste this source line replacing source line in my code.