Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Seasonality report

Hello,  I am trying to prepare a report where I need to see the items that has the month value as 1, Can someone suggest me how I can do that. Here's an example of the report    
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

Anonymous Use the Filters pane and filter for 1?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thank you, I tried it earlier but it only showed the result for the item in the particular month and removed all the others. For eg; i filtered the month Feb to show 1 and it removed all the other items that had 1 in Oct, Nov or dec etc 

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Anonymous,

      Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

      How to Get Your Question Answered Quickly  

      Regards,

      Xiaoxin Sheng