Dax formula

Hi zameenakarmali ,

Since you only want to present these two columns, but in the previous reply Active/Expired was a measure, this would be difficult to achieve out of context, so I'll provide you with an alternative by recreating an Active/Expired calculated column.

To do this, I've made some changes to the original data:

1. Added a Sales column to Table.

2. A new table named Status has been created:

Then here are the specific steps:

1. Generate a new table, Table 2, which is the Cartesian product of the tables Table and Quarter.

Table 2 = CROSSJOIN('Table','Quarter')

2. Create two new columns for Table 2.

QuarterNumber = LOOKUPVALUE(Dim_Date[Qtr No],Dim_Date[Quarter],'Table 2'[Quarter])

FinalActive/Expired3 = IF('Table 2'[QuarterNumber]>'Table 2'[End Quarter Number],"Active","Expired")

3. Create a new relationship:

4. Create a measure:

Salesvalue = IF(SUM('Table 2'[Sales])=BLANK(),0,IF(HASONEVALUE('Table 2'[Quarter]),SUM('Table 2'[Sales])))

5. Create a slicer using the field Quarter from Table 2 and create a table using the field from Status and Salesvalue.

Best Regards,
Zhu
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.