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.
Hi All,
I have date 2020-10-21 This date fall under Q4 and starting date of Q4 is 2020-10-01 Is there any dax formula by using i can calculate starting date of quarter for any specific date ?
Thnaks
Lavdeep
Solved! Go to Solution.
Hi @lavdeepk ,
You can use a variable to save a specific date and use this measure to show the start of the quarter of this date:
Start date of quarter =
VAR _Date =
DATE ( 2020, 10, 21 )
RETURN
DATE ( YEAR ( _Date ), ROUNDUP ( DIVIDE ( MONTH ( _Date ), 3 ), 0 ) * 3 - 2, 1 )
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @lavdeepk ,
You can use a variable to save a specific date and use this measure to show the start of the quarter of this date:
Start date of quarter =
VAR _Date =
DATE ( 2020, 10, 21 )
RETURN
DATE ( YEAR ( _Date ), ROUNDUP ( DIVIDE ( MONTH ( _Date ), 3 ), 0 ) * 3 - 2, 1 )
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
@lavdeepk , You have a function for that startofquarter
startofquarter(Date[Date])
https://docs.microsoft.com/en-us/dax/startofquarter-function-dax
remember it needs continuous dates
Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.
Thanks, Amit for the quick response I an aware of startofquarter formula where I have to pass the date column In my case I have don't have a date column only have a single date want to know that date quarter starting date using dax formula
Hi,
You must have a Calendar table with fiscal quarters defined. Only then will will Startofquarter function 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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |