TMSL Alter Column Description
I am a noob in TMSL and I need your help. I am trying to add a description to the column in Power BI Services with a command: { "alter ": { "object": { "database": "dataset_test", "table": "005_SHIP_TO_LOCATIONS", "column":"CREATION_DATE" }, "column": { "name": "CREATION_DATE", "description":"This is the new description" } } } The error I get is: Unrecognized command: alter . Check path '['alter ']', line 2, position 13. Could you help me to make it work? This is Power BI Premium and I TMSL works for table name modification, but I can't figure out how to change the column description.
Trying to Calculate Standard Deviation
Hello All, I am trying to calculate standard deviation and most of what I have found on the internet is based on columns in a table and I am struggling with how to write a DAX formula for use with an analysis server where the data pulls from. I have used this link as a basis and have made some strides in calculating the SUM and the Avg. In the screenshot below I have the table in which I selected a range of weeks and Repeat Dispatches in whcih I am trying to plot standard deviation for. For SUM I used the formula: *RDR SUM = CALCULATE(SUMX(VALUES('Dim - Calendar'[Fiscal Week]),([Repeat Dispatch 7 day Numerator]/[Repeat Dispatch Denominator])), ALLSELECTED('Dim - Calendar'[Fiscal Week])) For Avg I used the formula: *RDR Avg = CALCULATE(DIVIDE([Repeat Dispatch 7 day Numerator],[Repeat Dispatch Denominator]), ALLSELECTED('Dim - Calendar')) For Standard deviation I cannot quite find how to use the previous calculations to find standard deviation which should be .0266 based on the calculations I found with an online calculator. Any help would be appreciated. Dave
