How to generate queries in Query Editor with M Code

[BrianJ]

@deltaselect,

Along these lines, one thing you might find helpful is a “cheat sheet” that I developed to accompany Melissa’s awesome Extended Date Table. One of the things it provides is guidance for each field in the date table, what other field should be used to sort it.

Here’s the thread where you can obtain the cheat sheet free from Enterprise DNA:

New Cheat Sheet for Extended Date Table

Extended Date Table Fans, I’m pleased to announce the release of the new deluxe version of the Extended Date Table Cheat Sheet, an essential accompaniment to @Melissa’s awesome and recently revised Extended Date Table code. Click here to obtain the new version, which now includes not only all the field names and examples for each, but field type and information on how to sort every field in the table. We will update this with every major update @Melissa makes to the date table code. We hope…

I hope this is helpful

• Brian