Hi Avi, Thanks a lot for your video! It is very useful!! However, I had still a problem like today: November 1st. At this day I don't have the data of sales yet, but Sales Prior Year YTD calculates the data already of november. So my result was still biased for today. So instead of taking 'Calendar'FutureDate = "Past", I take now Calendar[MonthNum]
Hi @dirksmeyers877 , If you are using the Calendar provided by Avi, you can recreate the Future Date value to be past after the end of the day. = Table.AddColumn(#"Added CurYearOffset", "FutureDate", each if [Date] > = CurrentDate then "Future" else "Past" )
The download link for the PBIX file related to this video is missing from your website! Also, where to find the advanced video about building the forecasted chart? That should be part 2 to this video! Thanks for the help!
Thank you the video is handy... I am trying FutureDate and curYearOffset and I am facing a problem the curYearOffset is filtering the current year how can I see the data from the previous ? ... but you don't have this problem in your sample ...
Why a Power Query Calendar table and not a DAX calendar table? Looking at Singh's Ultimate Calendar table the start date is hard coded (StartDate = #date(2014, 1, 1) ). Is that not a limitation compared to DAX Calendar() ?!
Hey Steve, once you have both measures defined, you can just create another measure using the two. I call this the 'Lego Block' approach to building measures. You may see some examples of this in my RU-vid Tutorial ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-AGrl-H87pRU.html and full details on using DAX inside my training program www.learnpowerbi.com/training And if you have any additional questions or help join our live events: 👉 www.TalkPowerBI.com Power On! / Avi