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 ref table
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}
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.
createOrReplace
ref table Sales
measure 'Sales Amount by Due Date' = CALCULATE(SUM(Sales[Sales Amount]), USERELATIONSHIP(Sales[DueDateKey],'Date'[DateKey]))
formatString: \$#,0.###############;(\$#,0.###############);\$#,0.###############
lineageTag: c2fe3283-9d89-4bee-b219-09de50cc38c5
ref table 'Sales Order'
measure Measure = CALCULATE(Sales[Sales Amount by Due Date],Sales[Sales Amount]>0)
lineageTag: fd142fd3-7e80-4ac8-bd70-f0198948e754
annotation PBI_FormatHint = {"isGeneralNumber":true}
just worked for me, changed measure values from 1 and 2