Forum Discussion

Yamabushi's avatar
Yamabushi
Icon for Helper I rankHelper I
3 years ago

CALCULATE with month names

Hi,   I'm having a hard time understanding why a measure isn't working. I'm using the AdventureWorks DW If I try this measure, the filter context isn't changing: _TotalSalesByYear = CALCULATE([_...
Need Help
Yamabushi's avatar
Yamabushi
Icon for Helper I rankHelper I
3 years ago

Hi,

 

Thanks for typing the measures, they both work as I would like them to.

My question still stands though. Why does the measure I typed work when I reference the month number, but not when I reference the month name.

 

I was not looking for a solution but for a technical explanation 🙂

 

Thanks