Forum Discussion
Using > < does not work for me-Help
Hello guys, very new on this world, quick question: I want to create a column with this name HDD&SSD SN LEN between 8-18 , the idea is to extract the records which are equal or between 8-18 of a column. If I use this calculation:
IF('Raw Data Dump'[Part SN LEN]=8||'Raw Data Dump'[Part SN LEN]=18,1,0) then I received like 1 only those records equal to 8 and 18. How I can get the records in between? using > < does not work for me- Thanks in a
manrique1quiros , I think this should work
IF('Raw Data Dump'[Part SN LEN]>=8||'Raw Data Dump'[Part SN LEN]<=18,1,0)
if not
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
1 Reply
manrique1quiros , I think this should work
IF('Raw Data Dump'[Part SN LEN]>=8||'Raw Data Dump'[Part SN LEN]<=18,1,0)
if not
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.