Forum Discussion

cristianml's avatar
cristianml
Icon for Post Prodigy rankPost Prodigy
6 years ago

Hi reuben521 ,

 

I can't create another table as the model has many relationships with the actual Period table. I would like to find another way. I only need to create a Measure that could calculate the following :

 

Actual LCR / LCR from previous month

 

As I already have the measure "Actual LCR" I need create another measure with this but adding or filtering by previous month so I can divide both.

 

Thanks,

 

reuben521's avatar
reuben521
Frequent Visitor
6 years ago

cristianml 

 

Wow, no kidding that your data model is complex. However, having a dim_date table is cruicial for any data model, because the dim_date table should be the main source to slice and calculate around your fact table, in this case, it is your period table.

 

Also, creating a dim_date table won't add complexity to your data model at all, because it will always be a one(dim_date) to many (other fact tables) relationship, and there is no ambiguity.

After you have the dim_date table, just write:

 

calculate(actual, previsoumonth(dim_date))

 

that should work.

 

Hope this helps