I am trying to do a lookupvalue formula on filtered data. I am having issues combining the two. The goal is as follows: Filter table 1 to only return values that = a sepcific value in a column....
Hey guys! How are you? I have this sharepoint list named "AppUsers": I want to get this data in my power bi. So I added the sharepoint list into my PBI, and have the following: ...
Hello everyone, i have a rating table i selected 3 columns, customer ID, Date and Movie as Table.Distinct to remove their duplicates however some customers rated twice or more in the same movie...
Hi all, please i need help, i have a sales table, that has in "Stock" column duplicate values, i'm looking if there is a solution to delete duplicate values without deleting all the row. info; dup...
Dear Community, I do have to import data from Google analytics to check the total views per URL. Below is an example of the GA data stracture I'm importing: Table name = 'Dat...
I want to compare the text strings in four columns. If the string is the same in all four columns, then the score is 6. If none of the strings match, then 0. I can create six conditional col...
See my table above, which is just a subset of many rows. What I'm trying to do is only listing the correct row based on SKU & Type for the related Privilege. Privilege is important and ...
Morning (Odata connection) I have a RangeStart 01/01/2023 00:00:00 RangeEnd 31/12/2026 23:59:59 I implemented a dax fileter = Table.SelectRows(BaseOrder_table, each [SysMutationD...
I am needing help on how to get the count or total of each different category value from both the "VOC Issue" and "VOC Issue 2" combined. Below is my data and then an example of the results I'm looki...