Calculate The Occupancy Days Per Month In Power BI Using DAX

In this unique example, I will show you how we can dynamically show how many occupancy days per month in a matrix visual.

This is a great example of the power and simplicity of the DAX formula language. Where you can write a straight forward measure and extract some fascinating information and still be able to dynamically filter the data further to showcase varied insights seamlessly.

Enjoy working through this examples

Sam

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – http://bit.ly/2SGof6C

FREE COURSE – Ultimate Beginners Guide To DAX – http://bit.ly/2AyEb3P

FREE – Power BI Resources – http://bit.ly/2C2aBn3

FREE – 60 Page DAX Reference Guide Download – http://bit.ly/2AyEc7T

Learn more about Enterprise DNA – http://bit.ly/2RacRD3

Enterprise DNA Membership – http://bit.ly/2AAqa5u

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.