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
7 years ago

hi, v-juanli-msft 

The month worked, but my year changed to look like the one in the picture

My field is of type number,

if I change the field type to date in edit view

My BI Desktop is in the us,This problem is driving me crazy,Can you imagine why my year is like this

 

Best Regards

alan-li

v-juanli-msft's avatar
v-juanli-msft
Community Support
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
    7 years ago

    hi v-juanli-msft 

    That's fine, think very much

     

    best regards

    alan-li

  • 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