Median of the Total from Each Month
The current output of my measure is the total count across all months. I want to adjust my measure so that the output is the Median of the total for each month. Current Output: Output = 229 Desired Output: July: 56 August: 56 September: 60 October: 57 Median = 56.5 My measure is exluding November and December, so sometimes the median will be across 4 months, sometimes 5 months, and sometimes 6 months, depending on the time of year. Measure 3 = VAR SelectedDate = SELECTEDVALUE('LOI Date'[Days Until EOM Sort]) VAR CurrentTime = TIME(HOUR(UTCNOW()) - 5, MINUTE(UTCNOW()), SECOND(UTCNOW())) VAR ThresholdTime = TIME(12, 30, 0) VAR TodayDate = TODAY() VAR StartDate = EDATE(TodayDate, -7) -- 7 months back from today RETURN CALCULATE( DISTINCTCOUNT('Opportunity'[Id]), FILTER( 'Opportunity', IF( CurrentTime > ThresholdTime, 'Opportunity'[Days Until EOM] < SelectedDate, 'Opportunity'[Days Until EOM] <= SelectedDate ) && MONTH('Opportunity'[LOI Date]) = MONTH('Opportunity'[Close Date]) && YEAR('Opportunity'[LOI Date]) = YEAR('Opportunity'[Close Date]) && 'Opportunity'[LOI Date] >= StartDate && 'Opportunity'[LOI Date] <= TodayDate && NOT (MONTH('Opportunity'[LOI Date]) IN {11, 12}) -- Exclude Nov and Dec ) )
Dates (months) out of chronological order on x-axis of chart
Hello, I have a question regarding the order of dates along the x-axis of a chart created in power BI. I am showing the change in a feature for the last 6 months (Sept 2022 - March 2023).. I would prefer to see the most current date as the rightmost value on the x-axis (in the case of a trend in the time series, rearranging these dates has a great influence on the appearance of the line chart); however, Power BI seems to default list the month names in cxhronological order, disregarding the year. If I list the 'year' first, then only the year shows, without division by month. Does anyone know how to place the months in chronological order by year? For reference: the above image shows the x-axis when 'month name' and 'calendar year' are separately defining the x-axis as shown below: When combining the year and month hierarchically, the x-axis looks as follows (disregards the separate months): Any suggestions would be greatly appreciated. Thank you! 🙂
Month Abbreviation
Hi, in my data I have two fields YEAR and MONTH that I used to create a new column Date = DATE (Data[YEAR],Data[MONTH] ,1) and setting its data type as Date/time I obtain this: which I used to build different graphs., e.g. The problem is that I would use the abbreviated month to save space but I cannot find the way, I tried several approached but none of them worked. Could you help me?How to compare all-time monthly values and output percentage changes ?
Hello Community, I am experiencing difficulty creating a DAX Command that compares my monthly averages and percentage changes. I need to see all-time average rather than the average for the month. I will include the information below. I need to display the % change in a table with the following columns: Product Identification, (All time - 2022-9), (All time - 2022-10), and % change. I do not own the live dataset. Any help would be greatly appreciated. I will provide images below. Thank you! Best,
How to add previous month sales to current month sales
Hello all, I'm trying to compare the YTD sales with the goals on YTD format. This is the idea that I want to present: I can make a table adding the goal of each month, which then I can graph as the blue line. The table below: The problem I'm finding is how to add what was sold in Oct (in the image) with Nov, so those sales stack up in Nov, the same with Dec (which should be Oct, Nov and Dec stacked), and so on. The idea of the graph is to show how deviated the sales are resulting against the final goal amount. I tried with TOTALYTD, but it won't add up the months' results. Is there any other function? Or other visualization to achieve this? Thank you.
