Returning value from Table A if Table B condition meet Table A
Hi all, I am new to PowerBI and currently developing some dashboard by facing some issue. I have 2 tables - namely historical_data and current_weekly_data The historical_data consist of 3 columns, Issue Name, Open Date and Status shown below: The current_weekly_data will only consist of 1 column - Issue Name. What I wanted to achieve is to create the Open Date and Status calculated column in current_weekly_data table to achieve the following: I know this can be done using Merge in Power Query but the data is huge and having slowness in performance when doing that and hence I would request for some guidance in doing this using DAX. I have no idea how can I retrieve the value from historical_data table to be inserted into the current_weekly_data table if the issue name match.. any help would be very much appreciated. Thank you!
MSBI Retrieve Filters and Selected Categories (Values) in Filters
Hi, I have to been trying to integrate PowerBI to my system. For which I need to retrieve a prebuilt report and a specific page of the report. Then get the filters and Tables (if exist) of the report modify it as per requirements and push the values to the powerBI report to show the modified results. I have tried the REST API provided by the PowerBI which doesn't have any retrieve/get filter api. Then I tried PowerBI Client React which has a getFilter and getSlicer functions associated with report and page. But whenever I call getFilter, it always returns an empty array, even if the page has several filters. Can anyone please suggest me a possible solution for: 1. Retrieving all filters of a specific page of a report and the values that were selected by the user 2. Get the table(built as visual table) of that page if that page has any. Thanks in advance
