Forum Discussion

AndySmith's avatar
AndySmith
Helper III
2 years ago
Solved

Month Slicer/Filter not working

Hi   I am working wit tabular model and the data comes via our datawarehouse. There are fact tables connected to a date table. Linked by Date Value. When I bring in Year Month as the rows (for exa...
Need Help
  • sergej_og's avatar
    sergej_og
    2 years ago

    Hey AndySmith ,
    I tried to replecate on my model.
    It looks good to me.
    I tried TOTALYTD([Qty], 'Date'[Date], "30/06") -> Comm (1)

    and 

    CALCULATE(
            [Qty],
            DATESYTD('Date'[Date], "30/06")
    ) -> Comm (2)

    Seems to be smtg with your fields in your Date table.
    What is "Date Value" represents?

    Regards

sergej_og's avatar
sergej_og
Super User
2 years ago

Hey AndySmith ,
I tried to replecate on my model.
It looks good to me.
I tried TOTALYTD([Qty], 'Date'[Date], "30/06") -> Comm (1)

and 

CALCULATE(
        [Qty],
        DATESYTD('Date'[Date], "30/06")
) -> Comm (2)

Seems to be smtg with your fields in your Date table.
What is "Date Value" represents?

Regards

AndySmith's avatar
AndySmith
Helper III
2 years ago

Thanks. There was mismatch of data types for the date field. ALl fixed. Thanks agin