Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

dax filter non zero

Hi, I'm new in Power BI, and I try to see any method if I want to see the list of value are there never reaching zero in weekly.  The table will shown below: Timestamp Type Value 5/5/22 ...
Calculatetable
DAX
TopN
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    SpartaBI, for the week num how can I modify that last 7 days 

    calculate(sum(value),DATESINPERIOD('Calendar'[Date],max('Water Flow Monthly'[Timestamp]),-14,DAY))
    • SpartaBI's avatar
      SpartaBI
      Icon for Community Champion rankCommunity Champion
      4 years ago

      Anonymous saw you asked a question before accepting. You managed this question issue?

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Thanks, SpartaBI . Yes I figure out and thanks for your help