Query Resources Issue - Actual vs Budget Finance Report
I am trying to construct a matrix that displays my details as rows, presenting five years of data that includes both actual values and budget figures. Specifically, I have five years of actual data and budget values only for the current year, along with calculations for variances between current year (CY) and last year (LY) actuals, as well as the growth from CY actual to LY actual and budget performance. However, I'm facing a challenge because I lack a dedicated column for these particulars; instead, the data is sourced from various MIS columns across three different tables, with inconsistent naming conventions. I can create the visual representation, but it breaks when I attempt to filter the months using a slicer.
How to use SUMMARIZE inside a calculated column?
I'm trying to get information from aggregated version of my table into my original table as a column, but im not sure how to do it. Find the sample ecxample below The table contains 4 column - EMP_ID, DATE, MONTHLY SALARY, DESIGNATION I want to create new column called TOTAL SALARY which is the sum of salary for each employee available in data. There is time filter as well, like if I select 6 months in the filter visual the total salary should be populated as total six months salary. I couldn't find a way to do it in PBI using DAX/POWER QUERY. Please help me on this!! Thanks
Dynamic Measure Required with two slicer
Hi Folks, I'm trying to develop the dashboard by comparing two months and their uses of two slicers. I prepared the dashboard using Excel Formulas. please help to develop Power-BI As the Raw data is attached Excel is available. please refer it Google Drive Link for Excel File Please feel free to contact for more info if required. RAW Data Period Account Value X Value Y Value Z Fix Tata 4 3 5 Fix Birla 6 7 8 Fix Adani 7 8 9 Fix RIL 8 9 10 Fix Tata 9 10 11 Fix Birla 10 11 12 Jan Adani 11 12 13 Jan RIL 12 13 14 Jan Tata 13 14 15 Jan Birla 14 15 16 Jan Adani 15 16 17 Feb RIL 16 17 18 Feb Tata 17 18 19 Feb Birla 18 19 20 Feb Adani 19 20 21 Feb RIL 20 21 22 March Tata 21 22 23 March Birla 22 23 24 March Adani 23 24 25 March RIL 24 25 26 March Tata 25 26 27 March Birla 26 27 28 March Adani 27 28 29 April RIL 28 29 30 April Tata 29 30 31 April Birla 30 31 32 April Adani 31 32 33 April RIL 32 33 34 April Tata 33 34 35 Regards, MOHIT
There was an error communicating with Analysis Services + Maximum size allowed size of 1000000 rows
I have created a paginated report using Power BI dataset which has a composite model Direact Query (Dataflows) and Import Mode (Snowflake) and enabled deafult download of Paginated report to excel. Using slicer values of Power BI report as query parameters for Paginated report (Concatenated slicers values with Paginated report url and assinged it to action of button for downloading). For Members of workspace Paginated report works as expected. When a user with viewer tries to download paginated report from Power BI report, facing following error. Below failed attempts made: 1. Added build permission to dataset. 2. Maintained same privacy levels for both the datasources. In Power BI desktop as well as in Power BI service. 3. I have agg tables to take the load of Direct query data. 4. Tried XMLA endpoint as source for Paginated report. 5. Updated PowerPlatformdataflows datasource credentials. Thanks in advance.Parent and child calculation
i have a parent and child table, i wanted to calculate the values with respect to their root parents like a family tree Parent Child Value Site1 Site2 10 Site2 Site3 20 Site3 Site4 15 The output should be, Parent Child Value Output Site1 Site2 10 10 Site2 Site3 20 30 Site3 Site4 15 45 Thanks in advance
Excel formula into DAX to create calculated column in Power Bi
I have a table with thousands of lines as in the example below. I want to be able to group the information by InvoiceId column (A) then look at the value in (C) to return the expected result in column (E), but its proving somewhat difficult to write a DAX statement to provide this information in a new column in power bi, or power query in power bi. Note that in (A) there are multiple id numbers and multiple variations in (C), one rule is that when there are multiple lines with the same invoiceId and PO or No PO in column (C) then PO will always override No PO. If it is just a single or multiple line in (A) with the same value in (C) then it is true to return that value. Its only when i hit multiple variations in (C) to the same Id in (A) where i cannot get the expected result. I have a formula in excel that seems to work okay in excel table, but cannot convert to a DAX formula. I have provided this below if it helps please? =INDEX($C$1:$C$1000,MATCH(MIN(IF(($A$1:$A$1000=A1)*($C$1:$C$1000<>"No PO"),$D$1:$D$1000)),($D$1:$D$1000)*($A$1:$A$1000=A1)*($C$1:$C$1000<>"No PO"),0))
