Re: How do I put a slice name, [This_Row], and a c...

retailpartnerco · 01-05-2020 09:23 PM

Slice Name: Report
Column: Store Lists To Include In Report

I tried…

  - "Report"[This_Row].[Store Lists To Include In Report]
  - {Report}[This_Row].[Store Lists To Include In Report]
  - "Report"([This_Row].[Store Lists To Include In Report])
  - [This_Row]."Report"[Store Lists To Include In Report]
  - "Report"[Store Lists To Include In Report].[This_Row]

…But none of them worked

How should I write this? Thanks!

Suvrutt_Gurjar

Hi @retailpartnercom,

I believe you may wish to give more details such as below that could help the community members better to share their inputs.

Could you please mention,iIs this [Stores List] a list type column. Is it a 'Related Records" type column, meaning it is reverse reference column of all related records of a child record.

If it is a reverese reference column, do you wish this column to appear in the report with the parent table. Do you wish only the list of names of stores or other columns’ details of that related child table in the report?

Steve

[This_Row] isn’t a thing. Do you mean [_THISROW]?

There is no way to put a slice name, [_THISROW], and a column name together.

What are you trying to accomplish?

retailpartnerco

Hello @Steve and @Suvrutt_Gurjar! Thankyou so much for your help! I didn’t actually need to put together those 3. I tried what I was doing with the column name and slice name, and my thing didn’t work. I tried with the column name and This_Row, but that didn’t work. So I tried to combine all 3. But @Steve, you were right. I messed up the This_Row. The text in bold would have worked with _ThisRow, so that fixed my issue. Thanks!

How do I put a slice name, [This_Row], and a column together?