Sample Data Scenarios...???

[FurnBI]

Hi - thank you for the amazing work you all do, I've been lurking and learning for a while, which has greatly helped me!

I downloaded the MS Sample Pack for Retail Analysis.  

There is a hidden measure for SecenarioID that defines TotalSalesLY and other time comparison metrics.  

I'm trying to understand what this "scenario" situation is about, can anyone please help?  It's hidden, so I cannot see the underlying data.

TotalSalesLY = CALCULATE([TotalSales], Sales[ScenarioID]=2)

The real result - I understand using the date slicer to pull in comparison date ranges, but I would rather do this with measures / DAX.  

Thank you for the help!!!

[v-huizhn-msft · Accepted solution]

Hi @FurnBI,

[SecenarioID] is a column in Sales table rather than a measure. You can right click Sales table->Unhide all, you can see the [SecenarioID] in resource table as follows.



Best Regards,
Angelia