Forum Discussion

kalo1314's avatar
kalo1314
Regular Visitor
2 years ago
Solved

Slicer sometimes does not work

Hi all,   I have encountered a technical problem and need for a kind help.    I am trying to make a formula for a 12-month cumulative calculation.  I have made a date table to connect two fact ta...
  • Wilson_'s avatar
    2 years ago

    Hi kalo,

     

    This looks like a modeling problem. You should not need a Date Period table; any additional dimensional data should be in your Calendar table. Also, it looks like you have a table that filters your Date Period table, which is almost certainly incorrect modeling.

     

    Hard to give much more feedback than that given the limited view of the model itself. I just don't think this is primarily a DAX problem.


    ----------------------------------
    If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

     

    P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.