Last Quarter, This Day Last Quarter

[prakash11440278]

Hi All,

Please share the dax expressions for the below formulas. Measure is Qty and dimension date[date]. 

	Measure	Defined as	Measure Notes
1)	Total
	Qty	Sum of [qty]	Total Qty in Units
2)	Last Qtr		Measures for Last Fiscal Qtr
	Qty (U) - LQ	Sum of [qty] for Last Qtr	Total Qty in Units for Last Qtr
3)	This day Last Qtr		Measures for this day Last Fiscal Qtr
	Qty (U) - DLQ	Sum of [qty] for this day Last Qtr	Total Qty in Units for this day Last Qtr
4)	Cur Qtr		Measures for Current Qtr
	Qty (U)	Sum of [qty] this Qtr	Total Qty in Units this Qtr
5)	Cur Year		Measures for Current Year
	Qty (U)	Sum of [qty] this Year	Total Qty in Units this Year
6)	Last Year		Measures for Last Fiscal Year
	Qty (U) - LY	Sum of [qty] for Last Year	Total Qty in Units for Last Year
7)	This day Last Year		Measures for this day Last Fiscal Year
	Qty (U) - DLY	Sum of [qty] for this day Last Year	Total  Qty in Units for this day Last Year

[TomMartens · Accepted solution]

Hey,

this is the DAX code for the 1st measure you are looking for:

Total Quantity = SUM('<name of the facttable>'[<name of the quantity column>])

and here you will find all the other measures:

https://www.daxpatterns.com/time-patterns/

From my point of view it will be very beneficial if you try to figure out the measures by yourself, if you need further assistance, please provide a pbix file that contains sample data, like a dedicated calendar tabel and at least one fact table, upload the file to onedrive or dropbox and share the link.

Regards,

Tom