help using powerbi
5 Topics
Coverting a Visual Table into a Data Table in the same PowerBI
Hi there, Is there a way to convert or duplicate a Table Visual to turn it into a Data Table within the same PowerBI? I can export the Table Visual as a csv file and then do a separate analysis from there, but is there any way to do this within PowerBI where the table that is created is automatically updated when the visual table is updated? I tried creating a new table to try and use the SUMMARIZE function but the Table Visual is not selectable (because it is not a data table). Essentially I'm wanting to do further analysis based on one of the columns within the Table Visual without having to export it.Solved1.4KViews0likes4Comments
Count orders with specific conditions
I hope someone may assist me with this... Currently I have a table of projects that can be Won, Lost or No Realized, the column of this os really exisiting, the problem that I have is that the same project can have No Realized and Won Status in different dates, or Not Realized and Lost Status. However, I would like to know how many orders I have with No Realized Status if the project doesn't have status of Won or Lost previously example of the table ----------------------------- Project | Status A | No Realized A. | Won B | No Realized C. | No Realized C. | Lost D. | No Realized D. | Lost E. | No Realized F | No Realized --------------------------- So the result should be: won projects: 1 lost projects: 2 No realized projects: 3Solved1.8KViews0likes10Comments
RLS
Hi, Need your assistance. I currently have a RLS that restricts access for viewing employees information out of the base location. Typically the Leads can view details based on Team ID and base location. And now I have a new requirement where I want to share the details of an employee who is out of the location (team id) but share a common work ID. Example: an employee with X team ID and working on a different project out of his base location. So he has 2 work id's say it as A and B where represent the work ID of base location and B out side of base location. Because of my current RLS the Lead M is not ablebto view the details of B and X employee. I tried to create some intermediate tables which work id's and matching team codes. Here if I hard-coded the work ID the RLS is working but not sure how to make it dynamic. So that when a Lead login userprincipalname() should be checked against the Work ID and display the Offshore employees along with base location else the normal RLS will work as is. Can you please help me on this. Thanks, AkashSolved1.3KViews0likes3CommentsHelp with DAX formula to calculate value from previous day
I need to create a calculated column 'Inventory_value' that calculates for each PV/product/date the inventory as follows: The inventory of the day before for that PV/product + qty_em + qty_ref- qty_ven If the inventory of the day before is not present, it becomes 0. So far I've only made this and it doesn't work, because I always get a big value like as if its summing up all the rows together inventory_value = var current_dt = rimanenze_pv_day_nonoil[dt] var product = rimanenze_pv_day_nonoil[cost_prod] var inventory_before = CALCULATE( SUM(rimanenze_pv_day_nonoil[em_total_value]), FILTER( rimanenze_pv_day_nonoil, rimanenze_pv_day_nonoil[dt] = current_dt - 1 ) ) var inventory_true = inventory_before + rimanenze_pv_day_nonoil[em_qty] + rimanenze_pv_day_nonoil[rett_qty] - rimanenze_pv_day_nonoil[ven_qty] var result = IF( ISBLANK(inventory_before), 0, inventory_true ) return result The idea is that it returns that sum for each row, not all summed together. Does anyone have a clue on how to fix this? All the values are within the same table.Solved779Views0likes2Comments
Daily Phone Call Report
Hello community, this is my very first question about PowerBI. I'm trying to create a report that shows how many call are being made by a SDR day by day to make a comparative clustered column chart. I'm using 3 columns from my phonecall table which comes from a Direct Query to our CRM (Dataverse) so i know there are some inherit limits with that. For my x-axis i have "Actual End" Column. For my y-axis i have "count of statuscodename" I tried distinct and still not working. And the legend is the "Owner" My question is, what I'm missing and why my graph is displaying multiple bars. Thank for all and have a great day!581Views0likes0Comments
