Forum Discussion
I need Help With A Date Formula
Hello, Thank you so much for your time I will get right into the, So to explain the problem so you have more context I have a dashboard that is connected through CRM online and we have deals that...
You have to prepare your real data to same state as you have you sample in excel. Then just edit Source step of my query and refer your query name with real data (you can check it again in note below, but read carefully)
Ok I started a new connection and I loaded it through Dynamic 365 Online and then I clicked transform data and went straight to Advanced Editor and this showed up
let
Source = OData.Feed(There is a link here to the CRM Conection, null, [Implementation="2.0"]),
opportunities_table = Source{[Name="opportunities",Signature="table"]}[Data]
in
opportunities_table
where can I find my source is it all of it ?