Forum Discussion
TMDL Script to update multiple tables
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.
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
