Posts

Showing posts with the label CALENDAR

Calculate Values for the Same Fiscal Week in a Previous Fiscal Year with Power BI and DAX

https://www.mssqltips.com/sqlservertip/7133/compute-fiscal-week-calculations-with-power-bi-and-dax/  

Creating a Dynamic Calendar Date Range in Power Query

https://www.youtube.com/watch?v=lDjKS3Ur3ks  

Calculate Working Days in Power BI

  https://www.mssqltips.com/sqlservertip/6917/working-days-calculator-power-bi/?utm_source=dailynewsletter&utm_medium=email&utm_content=headline&utm_campaign=20210714

Calendar Over Run in Power BI

https://exceleratorbi.com.au/calendar-over-run-while-comparing-last-years-data   Don't display values for dates with no data.

Dynamic "Column" Headers for Time Periods in Power BI

https://www.youtube.com/watch?v=4emPkBiiCtg&t=123s  

Power BI Tutorial: Dynamically Filter By Today's Date

  https://www.youtube.com/watch?v=lkHFpmA4SJ4 In this Power BI Tutorial, Patrick looks at how to dynamically filter by today's date. Using a date table, you can create a DAX measure that can then be used as a Power BI report-level filter to dynamically filter by today's date within Power BI Desktop