Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

About creating a complex report

hi all As shown in the attachment, I want to focus multiple charts in one report. Now all I can think of is to use the toolbar to display, but now I need to filter in this chart.So the toolbar part ...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous 

    You could create a column first

    date column = RIGHT('Table (2)'[Column1],2)&"/"&"01"&"/"&LEFT('Table (2)'[Column1],4)

    Then use this date column in my formula.

     

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

hi v-juanli-msft 

 

Again, it's just a matter of the date

 

Just like in the picture, I have fields in my table but I still get an error

Is there a size limit on the RIGHT function, which is about 12,000 lines in this table

BI hint me not using a function that gets a single result

 

Do you know why

 

Best Regards

alan-li

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi Anonymous 

If [month] is a column, to use it in a measure, please use "MAX", or "SUM" ,,ect, for example

Measure1=Right(MAX([mONTH COLUMN]),2)

Best Regards
Maggie

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    hi v-juanli-msft 

     

     

    As you can see, this is a table field, But there's a lot of duplicates, and I can't delete it, so if I use the MAX function it's going to find my largest value which is 201908

    I also tried using the ALL function, but it still didn't work

     

    There is a troublesome way to add a column in the table to remove duplicate data, but I am not familiar with the M function, do you have an easier way? Let me know if you have. thinks

     

    Best Regards

    alan-li