Creating a mapping table based on date completed
I have a table for generating status reports. Users can provide the date range (Reporting Start and Reporting End) of the status report and provide some contextual data, like executive summaries or analysis. Ultimately, there are details that get pulled into this report that represent the work completed between the Reporting Start and End fields. Users can make as many status reports as they want for date ranges, meaning that multiple status reports should be able to display the same details, if needed. I want the details to simply show up when a status report is selected in Power BI. I need to create a mapping table that will give me the ID of the status report table plus the ID's of any items from the work table where Date Completed is between the Reporting Start and End from the status table. Can someone help me with the DAX structure for this table? I can't visualize it.
Combining Multiple Measures into a Unified Pie Chart Overlay on Power BI Map
Hello Power BI community! I have measures for sales, gains, and losses. I aim to display their aggregate in a pie chart overlay on a map (power bi default map - not Azure Map), segmented by measure type. I have the location set on town name and it works fine but I just need the measure to show in one bubble. Essentially, the measures would be in the legend and the value. For instance, a town might display 25M in sales, 21M in gains, and 12M in losses. While I can visualize each measure independently on the map and segment with a dimension column in the legend, I need a unified view for all three measures that is segmented by the measure type. How can I achieve this with the measure as the dimension in Power BI? I believe I am looking for a calculated table with a switch statement, but I am not sure.
Correct measure to use to mapping in Bridge table
Hi, Being a new bie to PBI Need help to arrive at correct measure to take in to account the bridging table . Recreated my actual case with simple sample data. Two fact tables,Three dim tables and a Bridge table. Bridge table has n to 1 relationship as well as 1 to n relation ship between ID1 and ID2 My current measure does not take in to account the relation ship while calculation as it still calculates the values for independent IDs and not taking the ID mapping to account. Expected correct values given in red after aggregation. https://drive.google.com/file/d/1NwijYKBDzng82mm6jXpthB8SkWAG1OJo/view?usp=drive_link Enclosing the PBIX sample file. Deeply appreciate your support. Thanks.
