Same period previous N months
I want to calculate total sales for previous N months for the same period according to the slicer. Eg if in slicer I select range from 1-10-21 to 3-10-21 the my column chart should display total sales for previous N months within this range. I wrote following Dax measure for the same but not getting desired result: same period = CALCULATE(SUM(financials[ Sales]),DATESINPERIOD('Date'[Date],MAX('Date'[Date]), -'Select N'[N Value],MONTH),FILTER(financials,AND(financials[Date]>=MIN('Date'[Date]),financials[Date]<=MAX('Date'[Date])))) Any suggestions are apprecited.Power BI Report builder | Matrix displays empty row on top with totals
Hi, I'm not sure if this is the right section of the forum, as I'm using the Report Builder from an existing report published in the Power BI service. In the original query in Power BI Desktop, my tables work just fine. However, in the Power BI report builder, I get an extra empty row for each level of the matrix with my total values as a value of the field. When I try to add functions to calculate the totals at the bottom of the table, my values are not correct because the formula picks up the values in those empty rows too. In the example above, the first row has empty values for Tenant ID and Batch, and the values of the columns are really the totals. So, if I sum the fields values for "Onboarded" in the total row, I get 66, while the correct value should be 33. How do I exclude that first empty row? It's really confusing... Thanks in advance! ~Alienvolm
Adding Target Line for 2023 Cumulative Costs in Power BI Visual
Hello Power BI Community, I am seeking assistance with a visual I've created to compare cumulative costs for the years 2022 and 2023. For the visual, I have developed the following measure for cumulative costs: ```DAX Cumulative Costs = CALCULATE( SUM('Cost 1'[Amount EUR]), FILTER( ALL('Calendar'[Date]), // Remove the filter context from the Calendar table YEAR('Calendar'[Date]) = YEAR(MAX('Calendar'[Date])) && MONTH('Calendar'[Date]) <= MONTH(MAX('Cost 1'[Date])) ) ) ``` This measure is placed on the Y-axis, with the Calendar Month on the X-axis, and the Calendar Year as the legend. My query is about incorporating a target line for 2023 cumulative costs into this visual. Currently, the use of the legend for differentiating between the years is preventing me from adding a secondary Y-axis. Is there a way to work around this issue? Should I create a separate measure to facilitate the addition of the target line? I have attached a sample of the data and a screenshot of the visual for your reference. Any guidance you can provide would be greatly appreciated. Sample Visual and sample Dataset Attached: https://drive.google.com/drive/folders/1IOviSSW_LKRWuyKH_R7Gh6RaDDj6_zZV?usp=sharing Best Regards, Manish TripathiUpload Multiple Files on Power Bi Report Server
We have a requirement to move around 50+ Reports from One Power Bi Report Server Instance to another so i would like to know is there any option so that we can bulk upload more than one file on the report server ? As per my understanding the upload file option in the report server only allows the upload one file at once and using Power BI Desktop also we can only upload one file so i would like to know any way by which we can upload more than one file on the report server.
Troubleshoot Very Slow Paginated Reports
We primarily use the PBI Service, however we have a couple onprem reports hosted in Power BI Report Server. To consolidate, we've moved our SSRS reports to be hosted on the PBIRS Server however performance for the same reports on PBIRS vs SSRS is worse by a factor of about 10x. PBIRS is running Sept 2022, and reports all come off our onprem warehouse so no gateway. It's also not hardware as the 2 servers are configured the same, same subnet, same service account... I'm using one of our simplest reports which is a select of about 600 rows from a user table - selects the whole table no WHERE clause. On SSRS it might take 2-4 seconds to render, on PBIRS it takes upwards of a minute. There appears to be 0 load on the PBIRS server or the database server. I don't know if it has to spin up engines or instantiate connections or what, but there is something very different in the processing between the 2. I've looked at SQL Server logs, windows event logs...but don't see anything. Are there any logs that will have the whole flow from the request hitting the RS, or can I enable some verbose logging? I'm just not sure where to go next.
Dynamically show data from current selection in slicer till max year in data.
Hello Community! I have a business requirement where I have to show data as follows- Suppose I have year slicer, when I select a year from the slicer then it should show data from selected year till current year (i.e 2017) in this case. Value will be added up in each row as shown. If I select 2017 then it should show only 2017-18 data. It should be dynamically changing with the year selected in the slicer till max of year. Can anyone help and guide me in this? Thanks in advance!Creating DAX rules to display received and sent dates based on one date column
Hello Folks, I really need your help to solve this problem that I have. I have the following sample data related to tickets treated during week number 15 of the month of April 2023, I would like to display the received and sent dates based on the Date of Action column (and only display the dates related to week number 15 of April, I have created a relationship btw between the date table and Date of Action column, but some outputs are still not correct), then calculate the time difference between the two (if the result is zero then it is understood that the ticket treatment was achieved in less than a day). I have implemented the following DAX calculations (thanks to user P_d2023 ) to get the results I have shown in the Power canvas belo PERSON_TIMELINE = RANKX(FILTER(WEEKLY_IDs, WEEKLY_IDs[Ticket_Nb] = EARLIER(WEEKLY_IDs[Ticket_Nb]) && WEEKLY_IDs[Sender_Name] = EARLIER(WEEKLY_IDs[Sender_Name])), WEEKLY_IDs[Date_of_Action], , ASC, Dense) TICKET_TIMELINE = RANKX(FILTER(WEEKLY_IDs, WEEKLY_IDs[Ticket_Nb] = EARLIER(WEEKLY_IDs[Ticket_Nb])),WEEKLY_IDs[Date_of_Action], , ASC, Dense) From the above calculations, I created the three columns shown in the Power BI report below: RECEIVED_DATE = CALCULATE(MIN(WEEKLY_IDs[Date_of_Action]), ALLEXCEPT(WEEKLY_IDs, WEEKLY_IDs[Ticket_Nb]), WEEKLY_IDs[TICKET_TIMELINE]=WEEKLY_IDs[PERSON_TIMELINE]) REPLY_DATE = IF( ISBLANK(CALCULATE(MIN(WEEKLY_IDs[Date_of_Action]), ALLEXCEPT(WEEKLY_IDs, WEEKLY_IDs[Ticket_Nb]), WEEKLY_IDs[TICKET_TIMELINE] > WEEKLY_IDs[PERSON_TIMELINE])), WEEKLY_IDs[RECEIVED_DATE], CALCULATE(MIN(WEEKLY_IDs[Date_of_Action]), ALLEXCEPT(WEEKLY_IDs, WEEKLY_IDs[Ticket_Nb]), WEEKLY_IDs[TICKET_TIMELINE] > WEEKLY_IDs[PERSON_TIMELINE]) ) Treatment Duration = if(INT([REPLY_DATE])-INT([RECEIVED_DATE]) <= 0,0, INT([REPLY_DATE]) - INT([RECEIVED_DATE]))
Create a measure for cases with multiple assignees in text box.
I have the following 2 meausres in my Power BI report: Number of Cases = DISTINCTCOUNTNOBLANK('PBI_XZ_Case_Time_Session'[Case_ID]) Number of Assignees = DISTINCTCOUNTNOBLANK('PBI_XZ_Case_Time_Session'[Created_By]) In the screenshot below, the table has the list of Cases with multiple assignees: the total cases with multiple assignees are 297,371. How may I create a new measure so that the total cases with multiple assignees (297,371) can be used in a text box?The 2nd line of split title doesn't show up
I have the following measure as the dynamic title for my table visual. It has UNICHAR(10) to split long title to 2 lines. Somehow, the 2nd line doesn't show up as shown in screenshot below. I can see the contents of 2nd line when hovering over title. The text wrap of the title is turned off. What's wrong with it? Title of Unassigned Sponsor Payments = VAR __SponsorID = IF( ISFILTERED('PBI_XZ_Fraud_Alerts'[Sponsor ID]), "Sponsor ID is " & SELECTEDVALUE('PBI_XZ_Fraud_Alerts'[Sponsor ID]) ) RETURN "Unassigned, Undetermined, Follow-Up Payments with Risk Assist and Blank Action " & UNICHAR(10) & __SponsorID & " in Last 91 Days up to Yesterday"
