powebi

I have this DAX that is supposed to return appointments for the same day last week by each brand for each date. It is working absolutely fine and giving me the desired results as I intended. The only issue is that for some brands, where there are 0 appointments for the current date, it shows 0...

Hi Peers, Need your guidance if possible. I have searched formums and google and cannot find a solution I dont know if this is even possible: I have the following code which works on a windows operating system. Which was taken from this site...

Hi. I have created 3 matrix tables (below). The first sums the KS (this stands for school key stages) per day. The second table is the running 7 days sum of those daily totals. And the third table is that 7 day total/divided by denominator *100000 For some reason the third table doesn't do the...

Hello ALL... My Goal: Find the most recent time that a student took a class. I have a table (called CLASSCOMPLETED) that contains the employreeID, CourseID, CompletedDate. I need to group by employee id, then group by courseID, then (in descending order of date) rank the classes. I think RANKX...

I Imported some data from folder. folder has 100 txt file. I need select txt file based on names listed in column2 at sheet2. Originally they are selected manually in power query and code is like that: let Source =...

So I have a Power BI screen that i created via Power BI desktop and the connection is to SharePoint Online List. I have on my screen 3 elements, a) date slicer to select the date range to b table, B) Table, dynamic filters the data based on A date slicer. C) a card visual to sum the total of...

Hi, I'm having an issue converting a MS ACCESS query to EXCEL powerquery. I found an online place to paste the statement into and it works fine. But I'm trying to change the query to have it prefilter the selected dates to speed up the pulling of data. Also was told to try query folding. The...

Hi, Im using the next code: =if(And([BB] = [MTDate],[AA] = [TesterName]),[MASTER_STATUS],"") that mean that if BB data is equal to MTdate data then check AA data equal to tester name, if all true take status data, if not paste "". What i would like to know if there is a possibility to...