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
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.