Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Show data for last 5 quarters from Fact Table

Hi All, We need your help here. We are showing data quarterly based on the latest quarters available in Fact table. The latest quarter in Fact table is Apr-Jun 2019. We want our report should show l...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Ashish Ashish_Mathur ,

 

Thanks for your reply. We dont have any date Slicer on the report to make any user selection. There is just a Bar graph which shows data for last 5 quarters and currently the latest quarter available is Apr-June 2019.

 

Thanks

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

I am not sure of how much i can help but can definitely try if you can share your PBI file.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi  Ashish Ashish_Mathur ,

     

    Thanks for helping me in this. Sorry, i am not allowed to share the actual data. But to describe my issue, We can go with an example. We store sale data quarterly, it does not get updated on daily basis. As per current date, the latest quarter we have is Apr-June 2019. 

    And when we say Sales in last 5 quarters 

     

    I hope it makes sense to you.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      7 years ago

      Hi,

      Your question made sense to me the first time i read it.  However, i cannot help you if i do not have data to work with.