Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.