Forum Discussion

PowerRobots99's avatar
PowerRobots99
Icon for Helper II rankHelper 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)
PowerRobots99's avatar
PowerRobots99
Icon for Helper II rankHelper II
2 years ago

Thank you SamWiseOwl, Excellent approach, really appreciate your response. 

 

Could you please let me know if there is any way to find out number of transactions that were scheduled between (5 Aug-11 Aug) AND also completed between (5 Aug-11 Aug),

 

To find out scheduled transactions between (5 Aug-11 Aug), we referred data that had uploaded on report date - 8/4/2024 in earlier step,

 

However, To find out completed transactions between (5 Aug-11 Aug), we have to refer data that have been loaded on report date - 8/11/2024.  

 

 

 

SamWiseOwl's avatar
SamWiseOwl
Icon for Super User rankSuper 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
    Icon for Helper II rankHelper 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
      Icon for Super User rankSuper 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
        Icon for Helper II rankHelper 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.