Forum Discussion
DAX
I need the following in DAX format. Requirement: I have a table called Transactions which has 3 columns ID, [Billing Type] and [Year-Month] as mentioned below. I need to create a measure that sho...
Anonymous
Please change the MEASURE to following
But i Have following observtions
1) 10 th occurence of ID 2 is in June
2) November 2017 date doesn't exist in your data
Measure = VAR mycount = CALCULATE ( COUNT ( TableName[ID] ), FILTER ( ALL ( TableName ), TableName[Year-Month] <= SELECTEDVALUE ( TableName[Year-Month] ) && TableName[RANK] = 10 ) ) RETURN IF ( ISBLANK ( mycount ), 0, mycount )
Sorry Zubair_Muhammad, The result is not as expected
Until April (2017-05) there is no 10th Credit Card. We have 1 in May (2017-05) and then 2 in October (2017-10). So we have to plot 0 till April and 1 till September and since we have 2 in October, we have to sum up the May 1 and October 2 and show as 3 from October to December
Anonymous
Please change the MEASURE to following
But i Have following observtions
1) 10 th occurence of ID 2 is in June
2) November 2017 date doesn't exist in your data
Measure =
VAR mycount =
CALCULATE (
COUNT ( TableName[ID] ),
FILTER (
ALL ( TableName ),
TableName[Year-Month] <= SELECTEDVALUE ( TableName[Year-Month] )
&& TableName[RANK] = 10
)
)
RETURN
IF ( ISBLANK ( mycount ), 0, mycount )