Add Days, Month, and Year to a noncontinuous Date column or stand-alone Value.
Solution Overview :
In Date we can add and subtract dateparts from respective Date PartsSolution: In date Add/Subtract Year, Month, and Day. You can even subtract more than 30 days or more than 12 months
Date = CALENDAR(date(2018,1-12,1),TODAY())
Today = TODAY()
Month Back Date = Var _DT = Today()
Year, Month, day Back Date = Var _DT = Today()
You can also find a pbix attached to this blog.
My Previous Blogs -
Date Difference Across Table- Direct Query Mode, Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard Time Periods and Comparing Data Across Date RangesConnect on LinkedIn
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.