Provide an option to add object definitions from TOM Explorer to an existing DAX script

[bernatagulloesbrina]

It would be convenient for a number of things, including seeing the value expression and the format string expression of calculation items side by side for example

[otykier]

DAX Scripts will have support for calc groups and calc items in a future update (planned for release soon). This will allow you to view both the calc item expression and format string expression for multiple calc items in a single document, or open multiple DAX scripts to view them side by side. Do you think that will suffice?

See also #57

[bernatagulloesbrina]

I see! Probably I need to get used to dax scripts. I seldom use them. I think I need an easy way to add measures to existing dax scripts from the model. is there one already or can only be done when you create a new dax script? El lun., 4 oct. 2021 8:34, Daniel Otykier ***@***.***> escribió:

…

DAX Scripts will have support for calc groups and calc items in a future update (planned for release soon). This will allow you to view both the calc item expression and format string expression for multiple calc items in a single document, or open multiple DAX scripts to view them side by side. Do you think that will suffice? See also #57 <#57> — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#238 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AJUUXHPKIDBYZ57ORGQIPW3UFFDHHANCNFSM5FGYG3CQ> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.

[otykier]

Just start to type "MEA" (for MEASURE) and auto-complete will guide you:

Once you hit F5, the measure will be added/updated in the model.

[bernatagulloesbrina]

Oh I see, but I meant to add the definitions of existing measures once the script is created. The quickest way is to type the name of the measure and right click on it and select add definition? I'd like to right click the measure in the object model El lun., 4 oct. 2021 8:48, Daniel Otykier ***@***.***> escribió:

…

Just start to type "MEA" (for MEASURE) and auto-complete will guide you: [image: adding-measures-through-scripts] <https://user-images.githubusercontent.com/8976200/135805590-ff065d93-630e-4e7b-a8c2-6388f932bb10.gif> Once you hit F5, the measure will be added/updated in the model. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#238 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AJUUXHO2TZNNHKR36TONDX3UFFE2RANCNFSM5FGYG3CQ> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.

[otykier]

I'd like to right click the measure in the object model

This is a good feature request. Currently, clicking "Script DAX" on a measure would create a new script, which you could then copy into the existing one, but I agree that it'd be good to have an "Add measure to script" option if you already have a DAX script in front of you.

[bernatagulloesbrina]

Awesome, thanks! El lun., 4 oct. 2021 9:59, Daniel Otykier ***@***.***> escribió:

…

I'd like to right click the measure in the object model This is a good feature request. Currently, clicking "Script DAX" on a measure would create a new script, which you could then copy into the existing one, but I agree that it'd be good to have an "Add measure to script" option if you already have a DAX script in front of you. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#238 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AJUUXHK7DUIVRKGY57COPGDUFFNGNANCNFSM5FGYG3CQ> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.

[otykier]

@bernatagulloesbrina did you know that you can include definitions of measures by right-clicking on a measure reference in a DAX script (or DAX query)?

As you can see there are two options - the first one will include the definition of the measure you right-clicked on, the other one will also include all dependencies of that measure.

[bernatagulloesbrina]

Awesome! that's beautiful El jue, 16 dic 2021 a las 22:51, Daniel Otykier ***@***.***>) escribió:

…

@bernatagulloesbrina <https://github.com/bernatagulloesbrina> did you know that you can include definitions of measures by right-clicking on a measure reference in a DAX script (or DAX query)? [image: image] <https://user-images.githubusercontent.com/8976200/146454199-4e04b399-2d5a-40b1-815f-ed9d27a4a402.png> As you can see there are two options - the first one will include the definition of the measure you right-clicked on, the other one will also include all dependencies of that measure. — Reply to this email directly, view it on GitHub <#238 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AJUUXHLLUQMDRW4AFB34IQ3URJNPHANCNFSM5FGYG3CQ> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>. You are receiving this because you were mentioned.Message ID: ***@***.***>

-- Bernat Agulló Partner & Data Enthusiast ***@***.*** +34 637 93 42 76 Balmes, 177 08006 Barcelona