March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
I'm looking to see if I can get the last date in a quarter.
I have 3 columns
- Year/Quarter (Formatted like 2019Q4)
- Quarter which contains the quarter number
- Year which contains the Year number i.e. 2019
I know the ENDOFQUARTER functions gives you the last day in a quarter however you need to input a date for this to work.
Is there another way to do it with the data I have above?
Thanks
Solved! Go to Solution.
@obriaincian , Try like
end of qtr =
eomonth( date([Year], 3*[Qtr], 1),0)
@obriaincian , Try like
end of qtr =
eomonth( date([Year], 3*[Qtr], 1),0)
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
114 | |
76 | |
57 | |
52 | |
44 |
User | Count |
---|---|
168 | |
116 | |
63 | |
57 | |
50 |