Forum Discussion

roelf's avatar
roelf
Icon for Helper II rankHelper II
8 years ago

Slice from FACT or RELATIONAL table

Hi   We use PBI Embedded and are trying to optimize the capacity usage.   I have a fact table with : Date | Template ID | Values   I have a relational table with : ID | Label | Template ID   ...
Need Help
Tips and Tricks
roelf's avatar
roelf
Icon for Helper II rankHelper II
8 years ago

Anonymous

 

 

Thanks again for your feedback - much appreciated.

 

I am happy to show you the data (Just not sure how much you are willing to look at - I can paste a screen shot of the model here if that will tell you something)

 

I am struggling to decide when to "clutter" the fact table with values using LOOKUPVALUE vs performing calculated columns by referencing data from the DIM tables.

 

 

Are there any particular online resources you can recommend ?

 

Thanks

Anonymous's avatar
Anonymous
Not applicable
8 years ago

roelf

 

You can post your data on here and explicit details on what you're trying to achieve but it may be a while before I can take a proper look at it.

 

Using USELOOKUPVALUE tells me a few things about the structure of your data. Post all and I (or others) can help.