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