Dax comparison operations do not support comparing values of type integer with the values of text.

[Anonymous]

per_fin =

SWITCH(

t_calendar[P1] = "4 Weeks",

t_calendar[P2] =VALUE( t_calendar[P1] + t_calendar[P2]) ,"8 Weeks ",

t_calendar[P3] = VALUE(t_calendar[P1] +t_calendar[P2] +t_calendar[P3]) , "12 Weeks",

t_calendar[P4] = VALUE(t_calendar[P1] +t_calendar[P2] +t_calendar[P3] +t_calendar[P4]) , "16 Weeks" ,

t_calendar[P5] = VALUE(t_calendar[P1] +t_calendar[P2] + t_calendar[P3] + t_calendar[P4] +t_calendar[P5] ), ">16 Weeks"

)

[Anonymous]

Hi @Ritaf1983 here is sample data 

[foodd]

Remember to adhere to the decorum of the Community Forum when asking a question.

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot). You can upload the PBIX file to a cloud storage service such as OneDrive, Google Drive, Dropbox, or to a Github repository, and then share a file’s URL.

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

[Ritaf1983]

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  

[Anonymous]

Hi @Ritaf1983  , i have p1,  p2, p3 , p4 and p5 columns as below

P1 = IF (t_calendar[row_num] <=4 ,"4 weeks" );

P2 = IF( t_calendar[row_num] <=8 ,  "8 weeks");

P3 = IF( t_calendar[row_num] <=12 , "12 weeks");

P4 = IF( t_calendar[row_num] <=16 , "16 weeks"); 

P5 = IF( t_calendar[row_num] > 16 , "16 weeks");
so now , i want final_per columns as below 1 column 

per_fin =

SWITCH(TRUE(),

t_calendar[P1] = "4 weeks",

t_calendar[P2] =VALUE( t_calendar[P1] + t_calendar[P2]) ,"8 weeks",

t_calendar[P3] = VALUE(t_calendar[P1] + t_calendar[P2] + t_calendar[P3]) , "12 weeks",

t_calendar[P4] = VALUE(t_calendar[P1] + t_calendar[P2] +t_calendar[P3] +t_calendar[P4]) , "16 weeks" ,

t_calendar[P5] = VALUE(t_calendar[P1] +t_calendar[P2] +t_calendar[P3] +t_calendar[P4] +t_calendar[P5] ), ">16 weeks"

)
So, here i want to get the data in slicer , when P1 selects then "4 weeks" data should show , and if P2 selects in slicer then "8 weeks" data show , recepectivly 12, 16 and >16 ..but this switch condtion getting as " Dax omparison operations do not support comparing values of type integer with the values of text." 

any help is appriciated 

[Ritaf1983]

Hi @Anonymous 
Sorry, I need the data to help...