Expression for counting of dates of current Fiscal year, Month, Quarter

Ask a Question

Hi,

I want to count no. of days with respect to different dimensions. As I have dimension as segment and month. I want to count total days for of current fiscal year wrt segment and want to count days in that month wrt month.

I want to achieve this from a single variable. Kindly suggest a set analysis from which I can achieve this:

(Desired output is from 1 Apr to 7 June, so total count of days are 68).

Desired output:

Segment_1	Days
	68
Agro Commodity	68
Aluminium	68
Buildestate	68
Common	68
IT Service	68
Lead	68
Non-Ferrous	68

Month	Days
	68
Jun	7
Apr	30
May	31

0 Replies