Value of the first month in a quarter or year

Kazu — Thu, 01 Jun 2023 21:11:16 GMT

The source data is like below.

Date	Value
Mar 2023	1
Apr 2023	1
May 2023	2
Jun 2023	2
Jul 2023	2

Using the data, I want to define a measure that shows the value of the first month, whether the values are shown by months, by quarter, or by year.

For example, in case of shown by quarter, it would look like below. Q1 is empty because there is no data for Jan. Q2 is 1 which is from Apr. Q3 is 3 which is from Jul.

Q1	Q2	Q3
	1	2

LIkewise, when shown by year, it would look like below because the value for Jan is null (not exist).

2023

I was able to show Q2 and Q3 values correctly by using FIRSTNONBLANKVALUE() like below. (pleae ignore why I use MINX. it is for other reasons)

FIRSTNONBLANKVALUE = FIRSTNONBLANKVALUE(Dates[Date], MINX('Fact', 'Fact'[Value]))

However, this does not work for Q1 or year because they show 1 from the March data. How can I show blank here? I want to achieve this in a single measure and don't want to create a separate masure for monthly, quarterly and yearly.

Re: Value of the first month in a quarter or year

Kazu — Sat, 03 Jun 2023 03:28:43 GMT

I was able to figure it out. Shareing the result hopeng it could help somebody else in future

topic Re: Value of the first month in a quarter or year in DAX Commands and Tips

Value of the first month in a quarter or year

Re: Value of the first month in a quarter or year