Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Dates filter when computing Value with SAMEPERIODLASTYEAR DAX

Hi PBI, prior to selecting filters the data in Matrix looks like this.. 

Sales $ LFY = CALCULATE(SUM(Sheet1[Sales$]),SAMEPERIODLASTYEAR(Sheet1[Month]))

When I select the 3 mths in the "Month FILTER", the table looks fine

When I select the "Quarter filter"...  the [Sales LFY] is missing

 

ASK - Is there a way where I can use either Month OR Quarter filters, without havig to create another New Measure = Sales $ LFY = CALCULATE(SUM(Sheet1[Sales$]),SAMEPERIODLASTYEAR(Sheet1[Fiscal Quarter]))

 

 

 

 

 

 

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Anonymous,


    Based on test, I found SAMEPERIODLASTYEAR function works not so smooth when filter on other fields.

    When you choose items, you need to manually select the related previous records, then the formula will works.

     

     

    Notice: When filter on other columns which calculate based on date column, it also works well.

     

    In summary, the function seems work based on the hidden calendar table which generate by date files. If you try to filter with other columns not contains relationship to hidden calendar table, the function will be broken.

     

    Regards,

    Xiaoxin Sheng