cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Build a string from a filter selection

Hi,

 

I am trying to build a string every time I make a selectiong from a filter I added from a table I added see the table below

 

The month the month that is selected in the filter must return the previous month string

e.g If the selected value is May the string must return APRFCST
If the selected value is Jun the string must return MAYFCST

If the selected value is Jul the string must return JULFCST

 

Month NumMonth Short
Apr1
May2
Jun3
Jul4
Aug5
Sep6
Oct4
Nov8
Dec9

 

1 ACCEPTED SOLUTION
v-xulin-mstf
Community Support
Community Support

Hi @Anonymous,

 

Create slicer table as:

Slicer = 
VALUES('Table'[Month Num])

Create column as:

Column = 
CALCULATE(
    MAX('Table'[Month Num]),
    FILTER(
        'Table',
        'Table'[Month Short]=EARLIER('Table'[Month Short])-1
        )
    )

Create measure as:

Measure = 
var _month=
CALCULATE(
    MAX('Table'[Column]),
    FILTER(
        'Table',
        'Table'[Month Num]=ALLSELECTED(Slicer[Month Num])
    )
)
return
CONCATENATE(_month,"FCST")

Here is the output:

vxulinmstf_0-1630919753061.png

The demo is attached, please try it.

 

If you still have some question, please don't hesitate to let me known.‌‌

 

Best Regards,

Link

 

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

View solution in original post

2 REPLIES 2
v-xulin-mstf
Community Support
Community Support

Hi @Anonymous,

 

Create slicer table as:

Slicer = 
VALUES('Table'[Month Num])

Create column as:

Column = 
CALCULATE(
    MAX('Table'[Month Num]),
    FILTER(
        'Table',
        'Table'[Month Short]=EARLIER('Table'[Month Short])-1
        )
    )

Create measure as:

Measure = 
var _month=
CALCULATE(
    MAX('Table'[Column]),
    FILTER(
        'Table',
        'Table'[Month Num]=ALLSELECTED(Slicer[Month Num])
    )
)
return
CONCATENATE(_month,"FCST")

Here is the output:

vxulinmstf_0-1630919753061.png

The demo is attached, please try it.

 

If you still have some question, please don't hesitate to let me known.‌‌

 

Best Regards,

Link

 

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

Anonymous
Not applicable

The below is what I am trying to achieve:

Forecast =
 
VAR FCST = ???? ****I need to build the string here****
 

RETURN
 
CALCULATE( Sum('ABF'[Amount]),
ALL('Forecast List'),
'ABF'[Category]=FCST )
 

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors