Showing working day no instead of calendar
Hello, i am facing a challenge where i want to have a bar chart showing daily invoiced sales, but instead of showing calendat day no number on x-axis i want to replace it with working day no. Data model setup: Base model: Tabular (storage mode: mixed) tables and dimensions used: 'Calendar'[ID] - linked to transaction table through a many to one relationship 'Calendar'[day no] - this is what i currently use on my x-axis. This is simply showing day number 1-30 depending on the selected fiscal year and fiscal month 'Calendar'[Fiscal Year] - used in dropdown to filter on fiscal year. runs from 1 july - 30 june 'Calendar'[Fiscal Month] - used in dropdown to filter on fiscal month. runs from 1 july - 30 june 'Global Measures'[Invoiced Amount] Requirements: Create a field to the calendar table return Working day no depending on the selected fiscal year and month. Working day counts as monday-friday, weekends is NOT a working day. Also public holidays should also not be taken into account. Working day should start counting from the first weekday of the filtered month and start over when a new month begins. Ideally, when using the field on the visual, weekends should be blank. I have tried to illustrate my idea through the snapshot below. The grey bars represent saturday and sunday to clearly distinct weekdays and weekends. So far i havent been able to find a working solution, so i am trying my luck making a post here. If there is any information needed regarding the data model or relationships etc. i will try to elaborate, just let me know.
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.
