I want to do Month to date and year to date calculation without using MTD and YTD functions. I know Today() stands for Today's date. In the same lines can someone please tell me how do I get the first day of current month (example 1/1/2017 currently) and first day of current year? TIA.
Solved! Go to Solution.
Cool my dear friend ,
try this one.
It will give u the first date from the date.
If u choose month it will give u the start of month, if u select year it will give start of year.
let me know if any help.
This is a way to easily calculate MTD and YTD without the need to calculate the first days first:
[SalesYTD] := CALCULATE ( [Sales], FILTER ( ALL ( 'Date' ), 'Date'[Year] = MAX ( 'Date'[Year] ) && 'Date'[Date] <= MAX ( 'Date'[Date] ) ) )
Taken from DAXPatterns here: http://www.daxpatterns.com/time-patterns/
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
How can I get the first day of month If I have "Year" as a parameter?
If year 2018 - I need May 1,2018
if Year 2017 - I need May 1, 2017 etc
Click here to learn more about the August 2022 updates!
Mark your calendars and join us on Thursday, August 25 at 11a PDT for a great session with Ted Pattison!
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.