Measure convert to column in the same table.
I have created a table with column name Tag, Images, Index. Below is the measure i use to view the image. Display Image = CONCATENATEX( d_images_1, d_images_1[Image], , d_images_1[Index], ASC) How can i convert it to column. The custom visual cannot use measure to display the images. Only column can. Thank you and regards, NickzNickzQuery Token Literal Expected Error
Hi ... I have reciece an error as below. How can i resolve the error ... let //Get list of files in folder Source = Folder.Files("imagas_path"), //Remove unnecessary columns RemoveOtherColumns = Table.SelectColumns(Source,{"Content", "Name"}), // Creates Splitter function SplitTextFunction = Splitter.SplitTextByRepeatedLengths(30000), //Converts table of files to list ListInput = Table.ToRows(RemoveOtherColumns), //Function to convert binary of photo to multiple //text values ConvertOneFile = (InputRow as list) => let BinaryIn = InputRow{0}, FileName = InputRow{1}, BinaryText = Binary.ToText(BinaryIn, BinaryEncoding.Base64), SplitUpText = SplitTextFunction(BinaryText), AddFileName = List.Transform(SplitUpText, each {FileName,_}) in AddFileName, //Loops over all photos and calls the above function ConvertAllFiles = List.Transform(ListInput, each ConvertOneFile(_)), //Combines lists together CombineLists = List.Combine(ConvertAllFiles), //Converts results to table ToTable = #table(type table[Name=text,Pic=text],CombineLists), //Adds index column to output table AddIndexColumn = Table.AddIndexColumn(ToTable, "Index", 0, 1) in AddIndexColumn Regards, Nickz NickzSort order breaks running total measure!!
I have a simple sales table below: 'Sales' This thrown into a simple Matrix looks like this: My objective is to move the TOTALs to the front of the matrix (left) and then to create a measure that results in a running total week over week of the Goal amounts. To do this I created a new table ( 'Week Order' ) to sum all data across all date points. See picture below: I then related the two tables on 'Sales'[Week] and 'Week Order'[Week Date] This allows me to use 'Week Order'[Week Of] as the column object in my matrix. Now I need to create a measure to calculate the running total of the Goal amounts. Goal Running Total = CALCULATE( sum(Sales[Goal]), FILTER( all('Week Order'[Week Of]), 'Week Order'[Week Of] <= MAX('Week Order'[Week Of]) ) ) When I throw this measure into the matrix everything works fine before sorting [Week Of]. You can see below that the running total for goals adds each week. 4/10/23 = 250, 4/17/23 = 100 + 250, 4/3/2023 = 125+ 100 + 250 Now, when I sort [Week Of] by [Order] the measure no longer compiles the Goal total each week. This is the problem I need help solving.
DAX Measure, Slicer Selected Last Date on Graph
Hello everyone. I've been banging my head against the wall trying many iterations of this. I've provided an example of the data below. Basically I'm trying to plot how many people finish a group of courses (the last day they finish a course in the selected group) vs. the date on a plot. The Class slicer can change to a users selection and is a separate table. I thought I would do something like this but am running into issues getting the proper value and plotting it on a visual. The user can select any combination of courses in the slicer. In the below example they have selected A, B, and C - which only four people have completed. Their final completoin date would then be plotted against how many users finished on that date. calculate(distinctcount(Table[Name],filter(Table, Courses Completed = Courses Selected && Table[Completed] = max(Table[Completed]) Without bringing in the date to a visual I can count the correct number of users that have completed all of the courses. CoursesSelected = calculate(countrows(CourseListTable)) Current Courses Completed = calculate(distinctcount(Table[Class])) Current People Completed = calculate(countrows(filter(values(Table[Name]),Current Courses Completed = Courses Selected))) I appreciate any advice or links to tutorials!
