Custom Month to date
Hello all, Our fiscal months are not based on calendar months but ends on the Saturday of every month. Therefore the our fiscal month starts on different day every month. I have the dax formula to calculate the last saturday of the month but I am not sure how to implement it to use in my slicer Here's the measure that give me the last saturday of the month customEOM = VAR dateVal = [Date] RETURN if ( dateVal > DATE ( '2018, 12, 31'), if ( dateVal > if ( WEEKDAY ( EOMONTH ( dateVal, 0 ), 1 ) = 7, EOMONTH ( dateVal, 0 ), EOMONTH ( dateVal, 0 ) - WEEKDAY ( EOMONTH ( dateVal, 0 ), 1 ) ), if ( WEEKDAY ( EOMONTH ( EOMONTH ( dateVal, 0 ), 1 ), 1 ) = 7, EOMONTH ( EOMONTH ( dateVal, 0 ), 1 ), EOMONTH ( EOMONTH ( dateVal, 0 ), 1 ) - WEEKDAY ( EOMONTH ( EOMONTH ( dateVal, 0 ), 1 ), 1 ) ), if ( WEEKDAY ( EOMONTH ( dateVal, 0 ), 1 ) = 7, EOMONTH ( dateVal, 0 ), EOMONTH ( dateVal, 0 ) - WEEKDAY ( EOMONTH ( dateVal, 0 ), 1 ) ) ), EOMONTH ( dateVal, 0 ) )
Custom Calendar fiscal year october
i want to create a day number on DAX Calendar. we have a custom calendar for fiscal year, our fiscal year stars on october 1 and i want to create a column when day #1 are october first, 2 october second... could you please help?, i alredy try trhu date dif: daynum#FIX = DATEDIFF ( DATE ( YEAR ('Calendario End Date'[Date]),10,1 ), 'Calendario End Date'[Date], DAY ) + 1 but when function comes to 1jan retun -273 thanks in advance for the helpCustomizable trend analysis for both point-in-time and cumulative data elements (pbix included)
Link to pbix download: https://childdevelop-my.sharepoint.com/:u:/g/personal/dhu_childdevelop_ca/EUl_HgKyoO1NmjwY1F0PypcBDF... In this sample dashboard, I included 3 sample data elements: # new referrals (cumulative) # clients currently waiting for service (point in time) average # days in service for active clients (point in time) I need to create a trand analysis visual for each of these data elements (plan to use line graph for cumulative and bar graph for point in time). The end users would like the following features: Customized date range and responsive point-in-time visuals: when users enter a start and end date (using a date slider slicer?), for example, if they enter 2021-04-01 to today, the "# clients currently waiting for service" visual will show number of clients that were waiting on 2021-04-01, 2021-05-01, 2021-06-01... etc. When a client is waiting on 2021-04-01, their referral date must be before or on 2021-04-01, and their start date must be after 2021-04-01. Customized date range and responsive cumulative visuals: when users enter 2021-04-01 to today, the "# referrals" visual will show number of cumulative referrals since 2021-04-01, this should be a trendline that always goes up If possible, have the option to switch between different time intervals (monthly, quaterly, yearly) for all the visuals. I think this could be achieved using date hierarchy and drill-down, but my end users tend to get confused by that and they want big buttons to click on. So another solution would be create separate visuals, and show/hide them using bookmarked buttons. Is there any other solution? The users want to be able to set the start date as any day of the month/quarter/year, and have the intervals fall on the same day. For example, if the interval is set to quarterly, and the user select "2021-03-02" as start date, the graph will show 2021-03-02, 2021-06-02, 2021-09-02, etc... if this is not possible, setting the dates to first day of the month/quarter/year within the selected time range is fine as well. Thanks so much! I look forward to discussing this with everyone 🙂
