Syntax Issues with API Call
Can anyone identify what is wrong with this function? I know a "Token Comma Expected" however, I cannot figure out to fix this problem. The bolded/underlined phrases below are whats giving me this problem: Source = Csv.Document(Web.Contents("https://ClinicalTrials.gov/api/query/study_fields?&fields=NCTId,LeadSponsorName,Phase,BriefTitle,Org...max_rnk=" & Number.ToText( limit )"&fmt=csv&min_rnk=" & Number.ToText( offset )),[Delimiter=",", Columns=7, Encoding=65001, QuoteStyle=QuoteStyle.None]),
Dividing and applying the value to another
I'm new to Power BI and haven't had any training so apolygises if the answer is obvious. I have a set of data Site Total Miles Site1 1000 Site2 2000 Site3 3000 Site4 5000 The total for Site4 needs to be split between the other 3 sites. The data is being pulled from a SharePoint list so needs to be dynamic as it will constantly be updating as well as being able to be shown on different visulations by site and also by user. I know how I'd do it in SQL but no idea what DAX syntax I need to use. Thanks in advance
What's wrong with my syntax?
Hi all, I am looking to create a measure that will take a count of cases sold and then return the average of it, however for the life of me I cannot figure out why my syntax is off? I tried using DAX formatter and that states I am missing an equal sign after average? VAR MaxDate = MAX ( 'Calendar'[Date] ) VAR MinDate = MIN ( 'Calendar'[Date] ) VAR SoldCaseIntCount = CALCULATE(COUNT ('Cases'[SoldCaseInt])) RETURN CALCULATE (AVERAGE (SoldCaseIntCount), FILTER (ALLEXCEPT ('Cases', 'Cases'[Settlement Officer]), 'Cases'[Sale Date] >= MinDate && 'Cases'[Sale Date] <= MaxDate) ) Let me know what you think...
