LAST N MONTHS WITH SELECTED MEASURES IN POWER BI | DYNAMICALLY SELECT PAST N MONTHS WITH ANY MEASURE

Check out the Combination of Field Parameter and Numeric Parameter in action and get all below answers-
- How do you do a rolling 12-month in power bi?
- rolling 6 months power bi
- last n months in power bi
- How do you display last 3 months in power bi?
- power bi last 12 months from selected date

Get Help into Questions Related to #powerbi , #dax , #powerquery Power BI #datamodeling , #analysisservices and #powerbiservice

Our videos are mostly specific to real time challenges faced into Power BI projects and its solutions. We use smart and most efficient techniques to solve such challenging situations in Power BI and DAX.

Checkout our playlist and SUBSCRIBE to our channel, for all such interesting topics in Power BI.

Follow us on LinkedIn
@POWERBIHELPLINE

[MorySavané-ut]

Thanks much! I was blocked when working on very important project for the company!
Good Job!

[pabloramirez]

i loved it, it helped me a lot, thanks, I was just blocked and this video put me on the rail again, thanks

[KMF]

Hi, this video has really been helpful. Thank you so much! If I changed this visual from a column chart to a matrix how would I remove all the months that are appearing with zero values?

[pranayvamshi]

This video helped me a lot, Thank you.

[feng]

All are great; please, if you could help me. I like to have the last 3 previous months (based on the current day, but without the current month) and no slicer.

[AkhilDuvvuru]

Hi @PowerBIHelpline, Thanks for this video. Really helps! Can you please help me with on how to get last 3/6/12 closed months including the current month to date? (Eg: If we are on 26th Dec and if I want last 3 months then I want to show Sep, Oct, Nov all full months + Dec till 26th)

[rafiah]

Hi, thank you for the video. May I know how to have the sequence of the Year-Month in the bar chart accordingly?

[dhananjaywalunj]

Hi, it's informative 👍. Can we do the same with the fiscal calendar as well?

[paulinapru]

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

[Robert-qntt]

Perfect example, very helpful! Similar doubt here. It works well but I only see those periods with data (bars for periods with no data are hided). If i want to see those hided bars i can show blank data (for X axis, period) but then i see all calendar periods, not only the last n.
Any idea to see only the last N even if they do not have data?
Thanks

[anindependentms]

Hi! Thank you for this video. It’s very easy to follow. But somehow, whenever I select a Month from the slicer, the chart will show zero values for the month(s) prior to that Month selected in the slicer. I can’t understand why. Can you help out? Thanks!

[anushaghiremath]

Hi, Thank you for this video. Have also tried doing the same I'm getting column total wrong for the last 4 months.

[dabarapraise]

pls did you create the dimdate table from the sales table then duplicated it?

[ramadhaninugraha]

Hi interesting tutorial, love it! Could you provide the pbix file to download and let us see the detail?

[RSSaucy]

Are you able to show or explain how you could have this functionality work with a Prior year bar also?

[SaravananBpve]

what is the formula used in the Period Column

[yousefesfahanian]

Why do you make the connection between two tables "one to many"? i guess it is wrong as we have only distinct values in both columns!

[sachinbhalerao]

Hi I want to select last month data dyanamically in report how can I do

[Guaify]

How to count Average sales in last 6 months ?

[thompham]

Can you give me that file again? thank you <3