Previous Year Measure for Line Chart
Hello. I am trying to create a YOY cumulative active customer by month line chart. The line should show the number of customers who made at least one purchase. One for Selected Year and another for Selected Year - 1. And, the total is rolling, so the line should be going up over time. Because there is a year filter in play, I am having difficulties writing a measure that provides a PY Active Customer line for the line chart. If I have 2026 selected, previous years' active customers is reduced. So, I have to removefilter the Calendar. However, this causes the PY active customer line ignore the month on the X axis resulting in a flat total line. Please help me write a measure that accurately calculates PY active customers and still works in a line chart. Should look something like this: Sample file here. Thanks.
No scrollbar at the x-axis
Hi Community, I've got the following X-axis (no scrollbar), but when I choose EOMONTH, the datapoints don't represent the actual graph. Is it possible to create a line-chart visual without a scrollbar, but with actual weeks, like 2020-18 - 2020-19 etc. etc. The format of the week is text and 2020-18 / 2020-19. When I try to make this number/date, for example 202018; between 202052 and 202101 there is a lot "white"space; In excel you can take the labels and there it is. Here, in PBI I find this very hard. Can someone help me? Thanks!
Time Intelligence Function - Do I need a calendar?
Hi, I am a bit confused if I would require a calendar for my data analysis. I viewed a post similar to my question but it did not give the answer I needed. My data is extracted from SAP to MS Excel as the example shown below. I am trying to perform an analysis of my current year actuals vs current year budget vs previous year actuals for each product group in respective to their country. This should be done as per the year to date figures. As you can see, my data does not have a calendar (day month/year) for each sales. Is this necessary? If so, what are my options? Posting Period Current Year Actual Current Year Budget Previous Year Actual 1 10,000 9,000 8,000 2 7,000 8,000 8,000 3 6,000 5,000 7,000 4 6,000 6,000 5,000 5 4,000 7,000 5,000 6 12,000 10,000 11,000 7 13,000 12,000 10,000 8 9,000 6,000 7,000 9 7,000 5,000 8,000 10 5,000 6,000 5,000 11 8,000 7,000 5,000 12 10,000 7,000 5,000 I'm currently trying to figure out how I can calculate the year to date values for each criteria (CY actuals vs CY budget vs PY actuals). With this, I want to summarise the data for each country/product group. I would really appreciate if you could help. Many thanks.
Calculating Total Employees each Month
Hi All, Looking to create a measure which tells me which employees are present at a certain month and year. I have a "Persons" Table with the following fields: Full Name, First Name, Last Name, Start Date, End Date. I have a "Calendar" table with the following fields: Date, Month, Year, YearMonth. Calendar is linked to Persons via an Active One to Many Relationship to Start Date. And a non-active relationship between date and End Date. How I can calculate how many staff at present at each month and year using this information. As the result I'm getting at the moment are only returning data for the month where people have a start date. For Example Aiden Sally's Count should appear from Jun 2018 - March 2023. For Example Yuliia Susan's Count should appear from Jun 2022 - March 2023.
