Forum Discussion

Brainscand's avatar
Brainscand
Frequent Visitor
9 years ago

Help with filtering/ sum by a date from a summary table

Hello,

 

im a new user so please exuse my basic understandings to what may be a simple problem.

My issues is this

I have 2 tables 1 is a summary table that i am summarising total per day for a month. The issue i am having is sum the total of column A, column B is the date and there re mulitple of the same day. I need to return the sum of column A based on the date that is derived from the Summary table. Any suggested will be greatly apreciated.

 

Thanks

 

Daryl

2 Replies

  • Mahesh0016's avatar
    Mahesh0016
    Icon for Super User rankSuper User
    3 years ago

    Brainscand 
    Total hours = 

    SUM('ABCD - Лист1'[Hours])

     

    Measure = SUMX(VALUES('ABCD - Лист1'[Date]),[Total hours])
  • Gokul_G16's avatar
    Gokul_G16
    Icon for Resolver I rankResolver I
    3 years ago

    Hi Brainscand ,

    Can please share the snap to better understanding your scenrio.

    Option.
    go to the modeling inside new table .
    Then make it inquice summarzice value. 
    = summarazice column ( table 1, column , column 2)..
    . and  aside try to use the date formula for month. new column
    = format (Date,"01-MM-YYYY"). this date formula is working by day wise data wil be calculating the month first date.

    Regrds,
    Gokulakannan. G