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

[@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.

[@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]

[@Nani-et7gk]

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

[@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"

[@paulinapru3224]

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

[@maazyousufkhan928]

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)?

[@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?

[@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