Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Condition to return text value

Hello!   I have the following tables:   Tab 1: Dayparts Daypart               Slot Start    Slot End Early morning       07:00          09:59 Morning               10:00          12:59 .........
Need Help
  • OwenAuger's avatar
    OwenAuger
    9 years ago

    Hi GeorgeAnonymous

     

    Just making sure - you should use the VALUES function (not the VALUE function) in that pattern.

     

    VALUES ( Dayparts[Daypart] ) is used to return a single value from the Dayparts[Daypart] column corresponding to each row of Programmes.

     

    (The VALUE function is used to convert text to numbers).

     

    The Dayparts table should not be related to Programmes for Static Segmentation.

     

    Here is a dummy pbix file illustrating how you could create a Static Segmentation calculated column using the tables in your example.

    https://www.dropbox.com/s/ike0q13pxhr3oca/Static%20segmentation%20time.pbix?dl=1

     

     

BhaveshPatel's avatar
BhaveshPatel
Super User
9 years ago

Hi There,

 

You need to create a index column at the query stage in both the tables starting from 1.

 

Create a relationships between the tables based on this column.

 

and then

1. Create a Calculated column in Table 2

Slot Ending = IF(Table2[Slot Mid Point]<RELATED(Table1[Slot End]),"True","False")

2. Create another calculated column in Table 2

DayPart = IF(Table2[Slot Ending]="False","NA",RELATED(Table1[Daypart])).

 

This will give you the results expected.

 

Please refer to the screenshots for more information.

 

 

Thanks & Regards,

Bhavesh