Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

last week number as a slicer

Hi All  ,  I need to create a report which procides compliance %  for last week. For this I need help to create a dynamic filter ("last promise week #" here). I am not able to use MAX as date synta...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Yes , "promise week" in the snapshot is the week #.

Thanks,

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

A Calendar/Dates table requires contiguous dates across your entire fact date range plus a little more depending on what date math you are doing.  "promise week"  is a fact table attribute.  Required, but not sufficient.  Can you show your data model?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi lbendlin , here is snapshot of the data model

     Thanks.

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      6 years ago

      that's just one data source in Power Query.  The data model in Power BI shows how your queries (data sources) are related. It's the third icon on the left.

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi lbendlin ,

         

        I am reusing an original built report. Its huge report with 20 tables, I am only 2 tables from it. please see below