How to use case kind statement to search and display out put on another column

Gopal_PV — Fri, 03 Feb 2023 10:26:48 GMT

Hi Folks,

I have Period ,FeeType, FeeDescri columns in my model. i want to add new column based on Period and Feetype.

Ex: 2022Q1 and QF then i want to add First Quarter 2002 + FeeDescri

Ex2: 202209 and MF then i want to add September 2022+ FeeDescri

Can we achive this with DAX. Please help me

Thanks in Advance.

Re: How to use case kind statement to search and display out put on another column

tamerj1 — Fri, 03 Feb 2023 11:41:25 GMT

Hi Gopal_PV
Please refer to attached sample file with the proposed solution

Result = VAR CurrentDescription = 'Table'[FeeDescri] VAR CurrentPeriod = 'Table'[Period] VAR CurrentYear = LEFT ( CurrentPeriod, 4 ) VAR MonthOrQuarter1 = SUBSTITUTE ( CurrentPeriod, CurrentYear, "" ) VAR MonthOrQuarter2 = IF ( ISERROR ( VALUE ( CurrentPeriod) ), SWITCH ( RIGHT ( MonthOrQuarter1, 1 ), "1", "First Quarter", "2", "Second Quarter", "3", "Third Quarter", "4", "Fourth Quarter" ), FORMAT ( DATE ( CurrentYear, MonthOrQuarter1, 1 ), "mmmm" ) ) RETURN MonthOrQuarter2 & " " & CurrentYear & " " & CurrentDescription

topic Re: How to use case kind statement to search and display out put on another column in DAX Commands and Tips

How to use case kind statement to search and display out put on another column

Re: How to use case kind statement to search and display out put on another column