Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Table formula issue

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
 
Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous,

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    HI Anonymous,

    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