Linked date hierarchy blank after scheduled refresh
Hi there I have a PBI report on our hosted PBI server. It is scheduled / updated nightly. I have a table (on left in image below) that has a Key and Last Updated fields. The Last Updated field has a relationship to a Date table that is created by a DAX (see code snip-it further below) and provides a hierarchy for Year/Month/Day. When you look at the table you can see the Year/Month/Day are blank. When I edit the PBI file in the Desktop app the table gets populated as I would expect (see image below). If I save the report all looks good on the PBI server but when the report is scheduled/updated the table reverts back. Any ideas why this is? Thanks for your time. Charlie Date = VAR BaseCalendar = CALENDAR(MIN('Autotime Query'[Week Worked]), MAX('Autotime Query'[Week Worked])) RETURN GENERATE ( BaseCalendar, VAR BaseDate = [Date] VAR YearDate = YEAR(BaseDate) VAR MonthNumber = MONTH (BaseDate) RETURN ROW ( "Day", DAY(BaseDate), "Year", YearDate, "Month Number", MonthNumber, "Month", FORMAT (BaseDate, "mmm") ) )
Power Bi averaging daily results to fixed budget
I am very new to Database work and Power BI. I have been tasked with creating a report that will calculate our daily hours for inservice ambulances and create a chart to compare it to our budgeted hours. I connected this very large database and built out a formula that looks at every shift start Date/Time and Stop Date/Time. I used the subtraction tool and then converted duration to a number. This all works. When I try to bring this into a chart and use the date Hierarchy to include year, quarter, month, day the averaging will not work. It bring it down to shift level. Is there a way to tally all the shifts in a day to compare it? Thank you for helping this Rookie. This is a small sampling of the data.
Variance measure, how to make it work with date hierarchy e.g. Month / Quarter / Year
Hi, I have the following measure DCM Month to Month Variance % = DIVIDE( [DCM], CALCULATE( [DCM], DATEADD('Calendar'[Date], -1, MONTH ) ), 0 ) -1 This works great for showing the month to month variance of the DCM measure. What I want to do is to be able to drill down through Month > Quarter > Year and have the measure adjust to that time period accordingly. What I am trying to avoid is having 3 charts displaying this i.e. one of month variance, one for quarterly variance etc. Is this possible to do?Counting rows before the selected period in slicer
Hi, My Fact table looks like below: Candidate Name Status Recruiter Full Name Job Ad Published date Timestamp Position Candidate 1 New PB 01/01/2020 02/01/2020 Support Worker Candidate 1 Phone screened KW 01/01/2020 05/01/2020 Support Worker Candidate 1 Interview complete PB 01/01/2020 24/01/2020 Support Worker Candidate 1 Offered role KW 01/01/2020 22/02/2020 Support Worker Candidate 2 New PB 01/01/2020 03/01/2020 Admin Officer Candidate 2 Phone screened KW 01/01/2020 05/01/2020 Admin Officer Candidate 2 Interview complete PB 01/01/2020 25/01/2020 Admin Officer Candidate 2 Offered role PB 01/01/2020 30/01/2020 Admin Officer Candidate 3 New PB 01/01/2020 03/01/2020 Finance Officer Candidate 3 Phone screened KW 01/01/2020 05/01/2020 Finance Officer Candidate 3 Interview complete PB 01/01/2020 25/01/2020 Finance Officer Candidate 3 Offered role KW 01/01/2020 30/01/2020 Finance Officer I need to calculate the following conversion rate for each position Formula is : Conv.rate per position =candidates offered role in current period/(interview completed in current period +previous periods) There is a slicer containing the Offered role date(Date hierarchy – Year, Month) Need the # of candidates that were Status=Interview completed before the slicer Period+Slicer period(Before selected offered Period-Month) Need the # of candidates that were status =Interview booked before the slicer period+Slicer period Need the # of candidates that were status=Phone Screened before the slicer period+Slicer period Need the # of candidates that were status=Offered role within the period selected in the slicer containing the Offered role date. Candidate name is considered unique. Appreciate all the help, Thanks,
Report Server: X-axis title not changing dynamically when drilling down date hierarchy
In my line charts I'm using a Date Hierarchy in the X-axis. When drilling up from Month -> Q -> Year, the X axis title should be changing accordingly (M -> Q -> Y) but it keeps saying just "Month". I tested on normal PBI Service and it works fine. Please advise. You can see in the gif below. (in the gif, x axis is saying "Month" in Vietnamese. I changed the Date Hierarchy names to English for easier understanding but the Vietnamese title didn't adjust itself for some reason) https://gfycat.com/aggravatingthoseblackrussianterrier
