Last 6 Months from Selected Date in Combo Chart | Advanced DAX | Power BI

Showing last 6 months in a combo chart of bar and line. It works around modelling and advanced DAX function.
PBIX File ... github.com/Bro...
Full set of Tutorials for Power BI
---------------------------------------------------
Introduction to Power BI (videos)
github.com/Bro...
Power Query (videos)
github.com/Bro...
DAX (videos)
github.com/Bro...
Visualization (videos)
github.com/Bro...
Service (videos)
github.com/Bro...
Interview Questions (videos)
github.com/Bro...
__________________________________________________________________________________
Kindly like, subscribe and share among Power BI aspirants

[@koushikmitra99]

This solution is based on Disconnected Table which is talk of the town now a days, and easy to understand. Thank You @BroRaj

[@emhych5498]

Fantastic video, thanks. Used the methodology and applied to previous x-weeks.

[@alexfurtado1759]

Very good @BroRaj .
Keep doing .....
Thank you
Alex
From Brazil

[@ernestomeyer7652]

This was very useful. Thank you for sharing.

[@Nani-et7gk]

BroRaj: Thank you for sharing the knowledge. Please do a video on how to explain project in an interview (PBI Developer)

[@sarihaddu]

Thank you so much. This video explains clearly how to do it. Could you tell me where I can learn basics of DAX for power BI such as what is value, expression, etc etc.

[@BroRajAnalyst]

msg me in whatsapp [phone]

[@paulinapru3224]

Thank you!!! This video really helped me. Instead of the last 6 months could it select all previous dates?

[@lokeshbatra3500]

this is really help ful i want to do the same for quarters. i need to show last two quarters on the basis of selected date. can someone pls help?

[@Islamicvideoskids99]

It is possible if I am selecting any month selected month showing sales unit sold and profit and other previous month showing only sales and unit sold (in unit matrix)?

[@zenny2027]

Hi, the other months are showing as straight line .

[@BroRajAnalyst]

Hope in the visual you've selected - "Expand all down one level in the hierarchy"

[@gpnaidu7813]

What if the selected month is Feb or March???

[@BroRajAnalyst]

Since we are creating the start date with DATE function, selection of FEB and MAR will work