Forum Discussion

Heena_9980400's avatar
Heena_9980400
Icon for Helper IV rankHelper IV
4 years ago

Need Help on dealing historical data in Power Bi

Hi Experts,   I am working on a project where I am dealing with 10 years of historical data(there is no live data) and the reports are ad-hoc reports we are not using any measures or logic(just kee...
data protection
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Heena_9980400 ,

You could start of with the use case.. If the business objective is to identify sales trend for the past 10 years. 
Then you could reduce the granularity of your data by  having  1 fact table (Sales Data) and multiple dimension tables related to the fact table. (Dimension table depends on the user requirements/ asking the user).

BR