DAX dynamic Percent change based on Calendar slicer.
Hello all, I'm trying to write a measure that calculates % change (MoM) based on the Date slicer. And the start date % change must show 0 irrespective of data. Currently, this is how the visual is displayed: DAX measures: 1. Prior Month Price Per Unit $ = CALCULATE([Net Price Per Unit], PREVIOUSMONTH('Calendar'[Date])) 2. Average Price Change % = DIVIDE([Net Price Per Unit] - [Prior Month Price Per Unit $] , [Prior Month Price Per Unit $] ) 3. Price Change % = CALCULATE([Average Price Change %], PREVIOUSMONTH('Calendar'[Date])) + [Average Price Change %] How can I show Jan/or any starting month as 0 and then MoM calc based on the start date and end date selected from the slicer. Any help is appreciated! Thank youRibbon chart incorrectly calculates percentage change when the old number is negative
Using the September 2022 GA release of Power BI Desktop for Report Server, I have identified a bug where the ribbon chart's percent change calculation is incorrect. In this scenario, the old value is negative and the new value is positive. Because the amount went up, the percent change should be positive. This value is not DAX - it is rendered automatically by the ribbon chart.
How to calculate percent change from month to month
Hello, I am new to Power BI. I am trying to calculate a month to month percent change. See the screenshot of the data below. This is a preview of what the data looks like I'm trying to get the difference between say Jan. 2021 (273) and Jan 2022 (248). First, I calculated the total admitted TotalAdmitted = CALCULATE(Sum(MarCom_Geomarket[Admitted])) Second, I tried to calculate the total admitted last month or last year to get the month over month difference and no data was generated. MoM Diff = VAR CURRENTVAL = [TotalAdmitted] VAR PREVVAL = CALCULATE( [TotalAdmitted], PREVIOUSMONTH('MarCom_Geomarket'[ApplicationSubmittedDate]) ) RETURN IF( [TotalAdmitted] <> BLANK(), DIVIDE(CURRENTVAL - PREVVAL, PREVVAL) ) I also tried using DAX using the SAMEPERIODLASTYEAR and PARARRELPERIOD Total Admitted LY = CALCULATE(SUM(MarCom_Geomarket[Admitted]), SAMEPERIODLASTYEAR(MarCom_Geomarket[ApplicationSubmittedDate]) Total Admitted LM = CALCULATE(SUM(MarCom_Geomarket[Admitted]), PARALLELPERIOD(MarCom_Geomarket[ApplicationSubmittedDate],-1,MONTH)) Nothing comes up when I add the field to the table Anyone have know what might be going wrong or what should be tried? Thanks so much for your help!
