DAX – Getting the Previous Year to Date Value up to and including the Current Month Selected – Not the entire Previous Year
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
Recent Posts
Tags
Azure
Azure Analysis Services
BI-NSIGHT
BI-RoundUp
Dataflows
DAX
Microsoft Fabric
Power BI
Power BI Premium
Power BI Premium Per User
Power BI RoundUp
Power Query
Power Query
SQL Server 2014
SQL Server Analysis Services
SQL Server Analysis Services Tabular
SQL Server Reporting Services
SSAS
Tabular Editor
Teams
Uncategorized