Forum Discussion
Solved
table visual with multiple values
Hello, I finally achieved a decent merge of source files into one table, which looks similar to the following table. Each row represent 1 server. I need to produce a table showing something like the ...
Hi,
OK please try the following.
1. Create a date table and join to the data table for filtering.
2. Add a month column to the date table using the FORMAT function. Add month as slicer.
3. Create 1st measure : (For ORACLE ONLY)
Count Per Day =Var Result = CALCULATE(COUNTX(SUMMARIZE(Sheet1, Sheet1[Date], Sheet1[OS]), 1),FILTER(Sheet1, Sheet1[Role] = "oracle"))RETURN Result4. Create 2nd measure:
MAX Value = MAXX('date', [Count Per Day])So using March and Oracle in your example gives me 2 because there are 2 dates with "Oracle" and thats the highest number. See screenshot.
Hope this helps. Let me know either way.
Hi,
The very first action you must perform on your dataset is "Unpivot Other Columns" in Power Query. For help on the result, for the sample table that you have shared, show the expected result.