Show Days Before Or After A Selected Date - Advanced Power BI Visual Techniques

Here, I'll run through an advanced analytical and visualization technique to use in Power BI.

Sometimes you may want to select a date but then show data and information around that date.

Due to the natural filtering that occurs via the data model, this isn't actually that easy to complete in Power BI.

I walk you through all the techniques to use in this detailed video.

All the best,
Sam
***** Video Details*****
1:30 - sample report
3:16 - checking out the date table
4:45 - setting up the model relationship of the dates
6:05 - working on the visualization for Sales from Selected Dates by Dates
6:50 - formula for the visualization
8:50 - an additional technique
***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-reference-guide-download
FREE – Power BI Resources - http://enterprisedna.co/power-bi-resources
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-dna-events-page/
*****Related Links*****
Show Results Up To Current Date Or A Specific Date In Power BI - https://blog.enterprisedna.co/show-results-up-to-current-date-or-a-specific-date-in-power-bi/
How To Work With Multiple Dates In Power BI - https://blog.enterprisedna.co/working-with-multiple-dates-in-power-bi/
Time Comparison For Non-Standard Date Tables In Power BI - https://blog.enterprisedna.co/compare-time-periods-with-non-standard-date-tables-dax-and-power-bi/
*****Related Course Modules*****
Mastering DAX Calculations - http://portal.enterprisedna.co/p/mastering-dax-calculations
Advanced DAX Calculations - http://portal.enterprisedna.co/p/advanced-dax-combinations
Time Intelligence Calculations - http://portal.enterprisedna.co/p/time-intelligence-calculations


*****Related Forum Posts*****
Find Date Of Last Result And Then Difference In A Data Table - https://forum.enterprisedna.co/t/find-date-of-last-result-and-then-difference-in-a-data-table-power-bi/1502
Sum Between Two Date Selected In The Slicer - https://forum.enterprisedna.co/t/dax-measure-sum-between-two-dates-selected-in-the-slicer/6008
How to showcase Budgets vs Actuals to today’s date - https://forum.enterprisedna.co/t/how-to-showcase-budgets-vs-actuals-to-todays-date/127
For more selected date queries to review see here - https://forum.enterprisedna.co/search?q=selected%20date

Видео Show Days Before Or After A Selected Date - Advanced Power BI Visual Techniques канала Enterprise DNA