Andres has attended:
Excel VBA Introduction course
Excel VBA Intermediate course
Power BI Modelling, Visualisation and Publishing course
Power BI DAX course
Power BI - Measures to show a list of values
Hi,
Could you please let me know how to get the results from the below measure4 in a column with each value in a single row instead of having all in a single cell?
I used CONCATENEX becuase it is the only way I can check the result.
If I just leave "ResultTable" after return, it does not work.
Measure4 =
VAR FilteredTable =
FILTER(
Skillko_Consolidation,
Skillko_Consolidation[Temporary Works Supervisor] >= TODAY()
)
VAR ResultTable =
SELECTCOLUMNS(
FilteredTable,
"TextValues",Skillko_Consolidation[Name & Surname]
)
RETURN
CONCATENATEX(ResultTable,[TextValues],", ")
Thank you in advance.
RE: Power BI - Measures to show a list of values
Hi Andres,
Thank you for the forum question.
I hope I understand what you want.
What about this column calculation:
Measure4 =If(Skillko_Consolidation[Temporary Works Supervisor] >= TODAY(),Skillko_Consolidation[Name & Surname])
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Power BI - Measures to show a list of values
Good Afternoon Jens,
Thank you for your response.
Please see below error message.
I have dates or empty values in column [Temporary Works Supervisor] and string in [Name & Surname].
Could you please review it and let me know how to make it work?
A single value for column 'Name & Surname' in table 'Skillko_Consolidation' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.
Thank you in advance,
Andres
RE: Power BI - Measures to show a list of values
Hi Andres,
Is the column in which you want the result in the Skillko_Consolidation table?
Do you use my IF?
If yes try:
Measure4 =If(Skillko_Consolidation[Temporary Works Supervisor] >= TODAY(),max(Skillko_Consolidation[Name & Surname]))
It will not return the right result but help me to understand the issue.
Blanks in your date column should not be a problem.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
