Forum Discussion

eburke's avatar
eburke
Icon for Helper II rankHelper II
8 years ago
Solved

banding not working

Hi all,   I've started using Banding for the first time, a fairly simple one spliting 24 hours into 4 bands, Table is set up as per below:     This has been used in a calculated column to ...
Need Help
BILASolution's avatar
BILASolution
Icon for Solution Specialist rankSolution Specialist
8 years ago

Hi eburke

 

Try this Calculated Column...

 

Time Bands = var actualtime = FIRSTNONBLANK('Actual Services'[Activity Start Time];1)
             var bandd = FIRSTNONBLANK(SELECTCOLUMNS(CALCULATETABLE(Band;Band[Low]<=actualtime;Band[High]>=actualtime);"Band";Band[Band]);1)
             var midnight = LOOKUPVALUE(Band[Band];Band[High];TIME(24;0;0))              
return

IF(ISBLANK(bandd);midnight;bandd)

Regards

BILAsolution

  • eburke's avatar
    eburke
    Icon for Helper II rankHelper II
    8 years ago

    Hi, thanks for this, it comes up with an error The syntax for ';' is incorrect.

    • BILASolution's avatar
      BILASolution
      Icon for Solution Specialist rankSolution Specialist
      8 years ago

      eburke

       

      Try to replace it by a ","

      • eburke's avatar
        eburke
        Icon for Helper II rankHelper II
        8 years ago

        Yes that worked, thank you so much :)