Reply
avatar user
Anonymous
Not applicable

DAX Help on Custom Quarters Calculation

Hi Expert, I am stuck one of the requirements, 

I have a file which has quarterly data, however, the output column needs only last date of each quarter to be updated as a value for respective quarter.

 

DateTotalQTRFinal Value (output)
Thursday, August 1, 201948984458642019-Q44432185600
Friday, August 2, 201950072031582019-Q44432185600
Wednesday, October 30, 201943621856002019-Q44432185600
Thursday, October 31, 201944321856002019-Q44432185600
Friday, November 1, 201949190640582019-Q14362185600
Saturday, November 2, 201948984458642019-Q14362185600
Tuesday, December 31, 201943621856002019-Q14362185600
Wednesday, January 1, 202043621856002019-Q14362185600
Thursday, January 2, 202043621856002019-Q14362185600
Friday, January 3, 202043621856002019-Q14362185600
Saturday, January 4, 202043621856002019-Q14362185600
Saturday, February 1, 202043621856002019-Q25562185600
Sunday, February 2, 202049190640582019-Q25562185600
Thursday, February 27, 202047791894582019-Q25562185600
Sunday, March 1, 202048878490722019-Q25562185600
Tuesday, April 28, 202043621856002019-Q25562185600
Wednesday, April 29, 202043621856002019-Q25562185600
Thursday, April 30, 202055621856002019-Q25562185600
Friday, May 1, 202043621856002019-Q36562185600
Saturday, May 2, 202043621856002019-Q36562185600
Sunday, May 31, 202047791894582019-Q36562185600
Monday, June 1, 202049392603102019-Q36562185600
Thursday, July 30, 202043621856002019-Q36562185600
Friday, July 31, 202065621856002019-Q36562185600



Please help me. Attached is the date for your reference.

https://drive.google.com/open?id=1WKQaoZIGDoYf-UyWaTt_Aua3U9bidiMs

 

Thanks

3 REPLIES 3
avatar user
Anonymous
Not applicable

Experts, still looking for some help on this request.

 

Any help much appreciated.

avatar user
Anonymous
Not applicable

Experts please help on this request.

avatar user
Anonymous
Not applicable

Experts any help please?

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)