topic Re: Need to show values till selected month in DAX Commands and Tips

Need to show values till selected month

Prabha45 — Mon, 23 Jan 2023 08:06:02 GMT

I had a year, month slicer. I need to show values(Measure) till the selected month in a matrix. If April 2022 is selected, the matrix should show values from 2022 Jan to April in the matrix.

Measure =
IF (HASONEVALUE ( Data[Category] ),
IF (
SELECTEDVALUE ( Data[Category] ) IN { "Phones", "Watches", "Shoes" },
AVERAGE ( Data[value] ),
SUM ( Data[value] )
))

Re: Need to show values till selected month

FreemanZ — Mon, 23 Jan 2023 08:31:50 GMT

hi Prabha45

try like:

Measure =

IF (

HASONEVALUE ( Data[Category] ),

IF (

SELECTEDVALUE ( Data[Category] ) IN { "Phones", "Watches", "Shoes" },

AVERAGEX (

FILTER(ALL(Data[Date]), Data[Date]<=SELECTEDVALUE (Data[Date])),

Data[value]

SUMX (

FILTER(ALL(Data[Date]), Data[Date]<=SELECTEDVALUE (Data[Date])),

Data[value]

)

this is supposed to work with a date column.

Re: Need to show values till selected month

Prabha45 — Mon, 23 Jan 2023 09:37:27 GMT

Thanks. but, I don't have a date column. Only year,quarter,month are available.

Re: Need to show values till selected month

FreemanZ — Mon, 23 Jan 2023 10:25:24 GMT

hi Prabha45

month in which format? month name or month number?

what rows and columns do you have the mentioned matrix?

Re: Need to show values till selected month

Prabha45 — Mon, 23 Jan 2023 11:05:41 GMT

Hi
Month name - Text(data type )
Rows - category
Columns - Month name, site
Values - Measure

Re: Need to show values till selected month

Prabha45 — Mon, 23 Jan 2023 11:45:47 GMT

Hi
Month name - Text( datatype)
Rows - Category
Columns - Month, Site
Values - Measure