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
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