Table formula issue

[JamesBowdidge]

Hi,

formular is.. 

Available_Table = groupby(SELECTCOLUMNS(

    FILTER(Cap_Data,Cap_Data[Gross Available]>0),

    "SlotDate",Cap_Data[SlotDate],

    "SP Type",Cap_Data[ServiceCentreReportingType],

    "CapacityRemaining", Cap_Data[Gross Available],

    "Site",Cap_Data[ServiceCentreName],

    "ChargeFlag",if(Cap_Data[IsNonChargeableFlag]=0,1,0),

    "FreeFlag",if(Cap_Data[IsNonChargeableFlag]=1,1,0),

    "DateTime",Cap_Data[SlotDateTime]),

    [Site],[CapacityRemaining],[SP Type],[ChargeFlag],[FreeFlag],[SlotDate])

my issue being that its missing rows that should be there (I think)

date value "Cap_Data[SlotDate]" is is just a whole date... date value "Cap_Data[SlotDateTime]" is the date and a time..

IE those 2 date fields in a row would read..

01/12/2022 & 01/12/2022 09:30

or

01/12/2022 & 01/12/2022 10:00

so the date may have 24 varianst to is (IE the date then the date and time)

However if I group by the date field the result of the table is missing rows.. seems to only give the first and last value (I think coiuld be wrong tho).. if I use the date/time field all the rows appear as I expect them too..

I want the table to be grouped by the "capacityRemaining" field.. and sim the capacty remaining.. 

pls help!

thanks

J

[v-shex-msft]

HI @JamesBowdidge,

Any update on this? It is hard to test and troubleshoot without any detail sample data, can you please share some more information about these?

Regards,

Xiaoxin Sheng

[v-shex-msft]

Hi @JamesBowdidge,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng