Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Working with timeline and measures

Hi to everyone!   I'm kind off stuck with some measures.   In my model I have two facts tables (SALES and SALES IMS) and one period table (PERIOD). The period table is made with the dates of SALE...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Anonymous,

 

Could you please post a sample with measures here? Maybe you could do it yourself. It's something like this:

Sales IMS =
VAR sales = [your old measure]
RETURN
    IF (
        ISBLANK ( sales ),
        CALCULATE ( [your old measure], SAMEPERIODLASTYEAR ( period[date] ) ),
        sales
    )

The table "period" should contain continuous dates.

 

Best Regards!

Dale 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi v-jiascu-msft

 

Thanks for your reply and help.

 

I've tried a measure like that before and didn't work. Anyway, after hours of thinking and work, I was able to work it out. The result is a measure that copied to Word fits in 10 pages. Yes! 10 pages!

 

The total scenary is so complex that I wouldn't know where to start explaining it.

 

Thanks for everything.

 

Have a great day!