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 UA-cam Tutorial ua-cam.com/video/AGrl-H87pRU/v-deo.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
Hi Avi, what if you have multiple past years, i.e 2017, 2018, 2019 and 2020?
Same question hereeee
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]
Glad you found the content useful
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" )
I was asked to do this today and you delivered!
Excellent, I had this problem years ago in Excel, now with Power BI is another thing, Great tip. Thanks for sharing
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!
Excellent video as usual from one of the masters! Thank you.
Could I know how did you do your calendar table though?
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 ...
How do I this if I'm comparing current YTD to Prev Yr Ytd and 2 Yrs ago YTD? Sameperiodlastyear adds the 2 previous years together. Thanks!
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() ?!
Iam a follower and i find your content intersting.
What about this....
Calculate ([Sales],Dateadd(datesytd(),-1,year))
This could work?
how do you show the variance betweeen ytd and prior ytd?
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 UA-cam Tutorial ua-cam.com/video/AGrl-H87pRU/v-deo.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
I need the context of this. I don't know what data you are using.
I have "intel core 2Duo 2.33GHz" Windows 8.1pro,,, i install power Bi but facing some problems to open,,,sir please help
he is explaining clearly but i still dont understand lol