Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Apply a filter to remove a specific date for DST

Hi, I have a table that shows days divided into 30 min segments, with a production total for each period and when there is a Daylight Saving day, there will be 50 or 46 segments, not 48. I need to b...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    According to the table you provided, I first created a date column.

    Date = Date(Left([DATE YYYYMMDD],4),Right(left([DATE YYYYMMDD],6),2),right([DATE YYYYMMDD],2))

     

    Then create two measures. The first meaesure is to calculates the sum of the output grouped by date.

    Sum = CALCULATE(SUM('Table'[OUTPUT]),FILTER(ALLSELECTED('Table'),[DATE YYYYMMDD]=MAX('Table'[DATE YYYYMMDD])))
    the best production day = CALCULATE(MAX('Table'[Date]),FILTER(ALL('Table'),[Sum]= MAXX(ALL('Table'),[Sum])))

     

     

    Best Regards,

    Stephen Tao

     

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

     

Thingsclump's avatar
Thingsclump
Icon for Resolver V rankResolver V
4 years ago

Hey Anonymous 

 

Can you please provide the input data as a table please. I belive the table that you have shown is result table.

 

Thanks

Thingsclump

www.thingsclump.com

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Thingsclump . I can't provide the actual table, commercial stuff and all, but the data looks like as shown. with  one extra columns. A date column (not formated as a date data type), a period column showing 1- 48 for most days, except daylight saving days, and a output column showing the production output as received from SCADA for each period.

I think I might have worked out a way aournd it, by duplicating the table, grouping by date, aggregating SUM of output data, and MAX period number. I'm then filtering out the days where MAX period = 50.