calculate the first instance on summarisecolumns

[Anonymous]

Hi Experts

is it possible to calulcate the first instance of a value when summarisecolumns in a new table in power bi. I want the first instance of column b in table A.

[parry2k]

@Anonymous please provide more info https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

See attached sample table...

I want to show in new table

Month Year      DaysinMonth     WorkingDayNUmber    Non-Working Days

Jan 2018           31                       22                                 1

Feb 2018          28                       19                                  7

Apr 2018          30                       20                                   2

etc.....

[AkhilAshok]

Not fully sure why you want a new table. Anyway, you could do like this:

Table New =
SUMMARIZECOLUMNS (
    Table[Month Year],
    "DaysinMonth", MIN ( Table[DaysinMonth] ),
    "WorkingDayNumber", MIN ( Table[WorkingDayNumber] ),
    "Non-Working Days", SUM ( Table[Non-Working Days] )
)

[Anonymous]

Hi Akhil. What would you do. Happen to learn.

[v-frfei-msft · Accepted solution]

Hi @Anonymous,

As the formula Akhil shared, I made one sample for your reference.

Table New = 
SUMMARIZECOLUMNS (
    'Table'[MonthYear],
    "DaysinMonth", MIN ( 'Table'[DaysinMonth] ),
    "WorkingDayNumber", MIN ( 'Table'[WorkingDayNumber] ),
    "Non-Working Days", SUM ( 'Table'[Non-working Days])
)

Also please check the pbix as attached.

Regards,

Frank