Forum Discussion

MadBern85's avatar
MadBern85
Icon for Helper I rankHelper I
1 year ago
Solved

Issue with SAMEPERIODLASTYEAR() and Date presets table

Hi I have made a table for date presets in my PBI-model, containing dates for "yesterday", "Current week", "Last week", etc. This is then connected to my calendar table on date values (many-to-one)...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    Hi MadBern85 

     

    Instead of a bi-direcitonal relationship, I would use many to many and set the relationship to flow from the presets to the actual calendar table. If that still doensn't work,  include REMOVEFILTERS(presetstable) to your formula.

danextian's avatar
danextian
Icon for Super User rankSuper User
1 year ago

Hi MadBern85 

 

Instead of a bi-direcitonal relationship, I would use many to many and set the relationship to flow from the presets to the actual calendar table. If that still doensn't work,  include REMOVEFILTERS(presetstable) to your formula.

  • MadBern85's avatar
    MadBern85
    Icon for Helper I rankHelper I
    1 year ago

    Hi
    REMOVEFILTERS() have been tried already, without effect.
    But changing to a many-to-many (which I of course hadn't tried already) seems to do the trick.

    Thanks a bunch 🙂