DAX – Getting the Previous Year to Date Value up to and including the Current Month Selected – Not the entire Previous Year

by June 6, 2017

So for this example it is best explained with an image below, then some additional context afterwards If you look above we have got the [Sum of Sales] for Dec 2010-11 NOTE: This I selected in the Slicer on the right hand side. Then I have created a Year to Date (YTD) measure which is the running total for the Year…

Power BI, Power Query 0

Power BI – Creating Dashboard Items that show MTD (Month to Date), or WTD (Week to Date), or YTD (Year to Date) dynamically changing based on your current period

by August 23, 2016

I have been working quite a lot with Power BI, and one of the great features is Q&A So what if you wanted to create a dashboard item that would always show you your sales for the current month (MTD), or current week (WTD) or current Year (YTD)? And always show the correct current period, without you having to go…

Power BI, Uncategorized 0