Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
@Baskar @Seth_C_Bauer @ankitpatira @BhaveshPatel @ImkeF @KHorseman @Greg_Deckler.
Solved! Go to Solution.
FirstDayofCurrentYear = DATE(YEAR(TODAY()),1,1)
Cool my dear friend ,
try this one.
FIRSTDATE(Dates)
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
It Works, Thank you very much ! 🙂
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
First Day of This Month = DATE(YEAR(TODAY()), MONTH(TODAY()), 1)
Proud to be a Super User!
Thanks, this has given me help on another problem I was having.
I did it but It doesn't work
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |