Forum Discussion
TMDL Script to update multiple tables
Can one TMDL script update measures in more than one table. I get a syntax error when I add a second
The above worked once I updated Power BI Desktop to the latest build. Here is the full script:
createOrReplace ref table Sales measure 'Sales Amount by Due Date' = CALCULATE(SUM(Sales[Sales Amount]), USERELATIONSHIP(Sales[DueDateKey],'Date'[DateKey])) * 3 formatString: \$#,0.###############;(\$#,0.###############);\$#,0.############### ref table 'Sales Order' measure test2 = CALCULATE(Sales[Sales Amount by Due Date],Sales[Sales Amount]>0) *2 annotation PBI_FormatHint = {"isGeneralNumber":true}
5 Replies
Yes
An example would be appreciated as clearly I am not getting this to work otherwise I would not have posted the question. I am looking for an example of updating 2 or more measures in different tables in one script. I've tried different variations of the following and I get a syntax error and apply error.
createOrReplaceref table Salesmeasure 'Sales Amount by Due Date' = CALCULATE(SUM(Sales[Sales Amount]), USERELATIONSHIP(Sales[DueDateKey],'Date'[DateKey]))formatString: \$#,0.###############;(\$#,0.###############);\$#,0.###############lineageTag: c2fe3283-9d89-4bee-b219-09de50cc38c5ref table 'Sales Order'measure Measure = CALCULATE(Sales[Sales Amount by Due Date],Sales[Sales Amount]>0)lineageTag: fd142fd3-7e80-4ac8-bd70-f0198948e754annotation PBI_FormatHint = {"isGeneralNumber":true}The above worked once I updated Power BI Desktop to the latest build. Here is the full script:
createOrReplace ref table Sales measure 'Sales Amount by Due Date' = CALCULATE(SUM(Sales[Sales Amount]), USERELATIONSHIP(Sales[DueDateKey],'Date'[DateKey])) * 3 formatString: \$#,0.###############;(\$#,0.###############);\$#,0.############### ref table 'Sales Order' measure test2 = CALCULATE(Sales[Sales Amount by Due Date],Sales[Sales Amount]>0) *2 annotation PBI_FormatHint = {"isGeneralNumber":true}Hi Anonymous ,
We really appreciate your efforts and for letting us know the update on the issue.
Please mark your reply as the solution so as to help other community members who may face similar issue in the future.Please continue using fabric community forum for your further assistance.
Thank you
just worked for me, changed measure values from 1 and 2
