Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter data per day in the report

Hello,   I have generated data for 150 employees for the last 5 years. In my SQL table. Currently, I have data like this in my table   Employee Id Employment start date Employment end date ...
  • Icey's avatar
    Icey
    6 years ago

    Hi Anonymous ,

     

    I don’t think you need to create another measure. Just remove "Trend data" column from your table visual.

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

maybe I didn't understand what the real need is, but part of the problem, at least, can be easily dealt with in power query with the table.group function

 

 

 

 

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Rocco,

     

    Thank you for your reply. I can do that but I have a date range. When a user selects a specific date then It should sum the data based on the selected date. I have around or less than 1 Million data for a direct queries. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      hi Anonymous ,

      then you want a function that has in input an ID and a data range i.e. {data1,data2}   and should output the salary sum (FTE sum) for that ID for days from data1 to data2?