Forum Discussion

PowerRobots99's avatar
PowerRobots99
Helper II
2 years ago
Solved

Demo Challange Matrix

Hello Friends, Please refer link with DemoChallange.pbix file.   https://drive.google.com/drive/folders/1S4iOi_u6aBEK0bJOko_Zvw29SES8jjqS?usp=drive_link  Now, our challange is to display numbers i...
Need Help
Show and Tell
Tips and Tricks
  • SamWiseOwl's avatar
    SamWiseOwl
    2 years ago

    Hi PowerRobots99  I think I have Friday fatigue...

    Completed date =
     var selDate = LASTDATE(Data[ReportDate]) --Capture current Report Date
      var lastweek = DATEADD(selDate,-7,DAY)
     var filDate =
     CALCULATETABLE( --modify filters
        FILTER(Data, [TransActualCompletionDate] > lastweek &&[TransActualCompletionDate] <= selDate)
        --only return rows after last week (excl 04) and to this week (inc 11/08)
        ,Data[ReportDate] = selDat--keep current report filter 
        )
     RETURN
     COUNTROWS(filDate)
SamWiseOwl's avatar
SamWiseOwl
Super User
2 years ago
Completed date =
 var selDate = LASTDATE(Data[ReportDate]) --Capture current Report Date
 
 var filDate =
 CALCULATETABLE( --modify filters
    FILTER(Data, [TransScheduleCompletionDate] > lastweek &&[TransScheduleCompletionDate] <= selDate)
    --only return rows after last week (excl 04) and to this week (inc 11/08)
    ,Data[ReportDate] = selDat--keep current report filter 
    )
 RETURN
 COUNTROWS(filDate)
 
Sounds like you just remove the last week filter
PowerRobots99's avatar
PowerRobots99
Helper II
2 years ago

I believe that is not correct,

 

We have to find out number of transactions that were scheduled from 5 Aug to 11 Aug by considering data with report date- 8/4/2024

AND

also completed between (5 Aug-11 Aug) by considering data uploaded on 8/11/2024,

Both conditions should meet,

 

Now, to find out completed transactions from 5th and 11 Aug, we have to use "TransActualCompletionDate"

 

In above measure, we haven't done that. 

  • SamWiseOwl's avatar
    SamWiseOwl
    Super User
    2 years ago

    Hi PowerRobots99  I think I have Friday fatigue...

    Completed date =
     var selDate = LASTDATE(Data[ReportDate]) --Capture current Report Date
      var lastweek = DATEADD(selDate,-7,DAY)
     var filDate =
     CALCULATETABLE( --modify filters
        FILTER(Data, [TransActualCompletionDate] > lastweek &&[TransActualCompletionDate] <= selDate)
        --only return rows after last week (excl 04) and to this week (inc 11/08)
        ,Data[ReportDate] = selDat--keep current report filter 
        )
     RETURN
     COUNTROWS(filDate)
    • PowerRobots99's avatar
      PowerRobots99
      Helper II
      2 years ago

      Hi SamWiseOwl 

      Thank you for reply, i appreciate your response on this, 

       

      Completed date =
       var selDate = LASTDATE(Data[ReportDate]) --Capture current Report Date
        var lastweek = DATEADD(selDate,-7,DAY)
       var filDate =
       CALCULATETABLE( --modify filters
          FILTER(Data, [TransActualCompletionDate] > lastweek &&[TransActualCompletionDate] <= selDate)
          --only return rows after last week (excl 04) and to this week (inc 11/08)
          ,Data[ReportDate] = selDat--keep current report filter 
          )
       RETURN
       COUNTROWS(filDate)

       

      With this measure. we can get number of Transactions completed between 5th Aug and 11 Aug by referring report date - 8/11/2024

       

      However, as i mentioned in a single measure, Both conditions should meet,

       

      1st Condition - We have to find out number of transactions that were scheduled from 5 Aug to 11 Aug by considering data with report date- 8/4/2024

      AND

      2nd Condition- Number of transactions completed between (5 Aug-11 Aug) by considering data with report date - 8/11/2024,

      Both conditions should meet,

       

      However, measure devised by you only take care of second condition.

      • SamWiseOwl's avatar
        SamWiseOwl
        Super User
        2 years ago

        Hi PowerRobots99 

        Measures can only return 1 value, do you want them added together?

        Can you make a mock up of what the answer will be please.