Forum Discussion

bberglund's avatar
bberglund
Frequent Visitor
8 years ago

SAMEPERIODLASTYEAR View

I have a data that i need to show this year vs. last year.  I found my issues for the contiguous data problem that throws the can't display the visual.    I need assistance on setting the function...
Dashboards
bberglund's avatar
bberglund
Frequent Visitor
8 years ago

This is the sample file look before i add the changes you had suggested. 

 

 

So I'd like to send this to you as a pbix and see if you can assist with the lower left chart for the last year data. 

 

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
8 years ago

bberglund

 

You can share the pbix file througn online file service like OneDrive.

 

Best Regards,
Herbert

  • bberglund's avatar
    bberglund
    Frequent Visitor
    8 years ago

    I sent you the file via private message. 

    Can you let me know if you got it?

  • v-haibl-msft's avatar
    v-haibl-msft
    Microsoft Employee
    8 years ago

    bberglund

     

    Do you mean that the TableauSalesView is the crossjoin table which I mentioned before? And there is only one fact table now without Calendar table, and you've already made the blank values shown as 0, right? Currently all the visuals are displaying well in the canvas, could you please point out the problem now?

     

    Best Regards,
    Herbert

  • bberglund's avatar
    bberglund
    Frequent Visitor
    8 years ago

    In the sample I sent, I did not have the extra tables you sent. 

     

    The dashboard works as is in small data ranges. 

    When you select 8/6/17 - 8/12/17 for example, the lower left chart throws an error. 

    I know the problem is that on one of the days last year for the LY column there as no sales for a particular category. 

     

    I couldn't get the calendar and the cross join implemented correctly. 

    Cot sure if you can give that a try in that sample and make it work? 

    then i can review it... cause i am missing something, somewhere.

    I'll send you the pbix file that i tried your methods on and you can see the error there as well.

     

    Thanks