Forum Discussion

jcampbell474's avatar
jcampbell474
Icon for Helper IV rankHelper IV
7 years ago
Solved

Please help w/DAX

I'm relatively new to PBI & DAX, looking for some guidance with this expression.   Using a fiscal (master) calendar, I need to calculate sales for the previous week.  I have two tables, Fact and Ma...
Need Help
  • jcampbell474's avatar
    jcampbell474
    7 years ago

    Filtering the Master Calendar table (via DAX) in the expression didn't filter the Fact table, so I just added fiscal date columns to the fact table and applied the filter(s) there, using DAX.

     

    It works fine.

jcampbell474's avatar
jcampbell474
Icon for Helper IV rankHelper IV
7 years ago

I also tried this.  Adding it to the post for clarification.

 

NBWTD =
VAR PYW =
    SELECTEDVALUE ( DateReference[PrevYearWeek] )
RETURN
    CALCULATE (
        SUM ( QMFact[BoundCount] ),
        FILTER ( Master_Calendar, Master_Calendar[FiscalYearWeek] = PYW )