Forum Discussion
DAX Measure reference error
Dear Colleagues, I get an error when I am referencing the following Measure. CurrentMonth:=CALCULATE( MONTH(Max(Merge1[Date])), Merge1[SalesR2017]<>0) The value of this CurrentMonth mea...
Hi ViorelCa
I checked my measure once again. It works for my data.
I would need more details about your data model to help you. Without I can't help you. Sorry.
Maybe @MattAllington can help here?.
Hi Anonymous
This is the Table:
| StoreCode | StoreName | Date | SalesPlan2017 | SalesReal2017 |
| xxx | yyy | 1/1/2017 | A | B |
| xxx | yyy | 2/1/2017 | A | B |
| xxx | yyy | 3/1/2017 | A | B |
| xxx | yyy | 4/1/2017 | A | B |
| xxx | yyy | 5/1/2017 | A | 0 |
| xxx | yyy | 6/1/2017 | A | 0 |
| xxx | yyy | 7/1/2017 | A | 0 |
| xxx | yyy | 8/1/2017 | A | 0 |
| xxx | yyy | 9/1/2017 | A | 0 |
| xxx | yyy | 10/1/2017 | A | 0 |
| xxx | yyy | 11/1/2017 | A | 0 |
| xxx | yyy | 12/1/2017 | A | 0 |
I need to calculate dinamically the sales only for the current month (April).
Many thanks,
Viorel