general comments
5 TopicsWhat's the difference between Firstdate/Lastdate(Date.Date) and Max/Min(Date.Date)?
I'm curious to know what the difference is as using this equation Calculate( [Total], Filter(All(Date), Date[Date] < Firstdate(Date[Date])) yeilds blank as a result but, Calculate([Total], Filter(All(Date), Date[Date] < Min(Date[Date])) gives the correct result. I assume Firstdate/Lastdate is syntax candy and contains a calculate statement which changes the filter context but, why?Solved2.5KViews0likes1Commentswirl function
Hi, Please help me with swirl function. this is what i get and stuck with it > my_mean <- function(my_vector) { + sum(my_vector)/length(my_vector) + } > my_mean(c(2,3,4)) [1] 3 > [save] > submit() | Sourcing your script... | Not quite! Try again. | Use the sum() function to find the sum of all the numbers in the vector. Use the | length() function to find the size of the vector.2.3KViews0likes1CommentPower BI Formula Help
Hello, I'm having problems getting an expression to work as I am getting the "Expressions that yield variant data-type cannot be used to define calculated columns". This is what I entered "QC Release Date = IF(IM_ItemWarehouse[Warehouse Code] = "QC",DATEADD(IM_ItemCost[ReceiptDate],17,DAY),"")" I bascially need to say that if an item is in a specific warehouse, then add 17 days to the "Receipt Date" else Null. Can someone help me with thisp please? Thank you!2.2KViews0likes3Commentsbuscar 5 maiores valores de uma coluna/find 5 highest values in a column
Ola boa tarde alguem pode me ajudar? Quero fazer um filtro de uma coluna e mostre apenas os 5 itens de maior valor. Por exemplo tenho uma coluna com produtos e valor vendido; Eu quero buscar quais foram os 5 itens que mais foi vendido e seu respectivo valor total de vendas. Translated: Hello good afternoon could someone help me? I want to filter a column to only show the 5 items with the greatest values. For example, I have a column with products and value sold. I want to find which ones were the 5 most sold and their respective total value in sales.Solved5.6KViews0likes5Comments