Produce a user friendly week identifier such as:
W12 Week Starting 3/25/2018
W13 Week Starting 3/30/2018
W14 Week Starting 4/8/2018
Also the PBIX makes slight improvements t...
Refer
Power BI — WTD Questions— Time Intelligence 4–5 https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
Week is not so Week https://c...
Similar to Rolling Months, https://community.powerbi.com/t5/Quick-Measures-Gallery/Rolling-Months/m-p/391499
it is often handy to have the ability to do rolling weeks.
F...
Produce a user friendly week identifier such as:
W12 Week Ending 3/31/2018
W13 Week Ending 4/7/2018
W14 Week Ending 4/14/2018
mWeekEnding =
//Get information a...
Suppose you need to know the first working day of the month and whether today is the first working day of the month. Use these measures:
First Working Day
First Working Day of Week...
Power BI provides great time intelligence features to calculate Year-to-date (YTD), Month-to-date (MTD) and Quarter-to-date (QTD) totals. There is no such thing as Week-to-date (WTD) or Period-to-d...
Objective -
To have a calendar that has a week start date that can start on any weekday
Solution -
The solution should use a weekday as a variable and should create a calendar t...
Any Weekdays Week Start Day - Just one variable apart.pbix (131 KB)
The Time intelligence features of Power BI are fantastic. But, let's be honest, they can also be a little frustating at times, have certain limitations and require data that actually has, well, dates...