Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have two table 1st consist of ISD number and in 2nd table I have range and country name.
From 1st table I took 1st 8 digit of ISD number. Now I want to find this 8 digit number follow in which country from my 2nd table. But there is no common column or any criteria in these two table, so I have added one more column in my 2nd table as ISD to make relation in two table still give me error. Please see the below error
My Formula is :
1st Table (Hyd Dec CDR 2018) 2nd table ((Sheet1)
finalCalledPartyNumber | Call Type | ISD Type | ISD Type | Country | Start Area Code | End Area Code | Call Type | |
0018043000 | ISD | 00180430 | 00180430 | US & Canada [Toll-free - 001844] | 00184400 | 00184499 | ISD | |
00440140771 | ISD | 00440140 | 00440140 | US & Canada [ISD] | 00188900 | 00188999 | ISD | |
0044012682 | ISD | 00440126 | 00440126 | US & Canada [ISD] | 00187800 | 00187899 | ISD | |
00440140771 | ISD | 00440140 | 00440140 | US & Canada [ISD] | 00186700 | 00186700 | ISD | |
0018004428 | ISD | 00180044 | 00180044 | US & Canada [ISD] | 00185600 | 00185699 | ISD | |
0018004428 | ISD | 00180044 | 00180044 | US & Canada [ISD] | 00184500 | 00184599 | ISD | |
0018004428 | ISD | 00180044 | 00180044 | US & Canada [ISD] | 00180100 | 00180199 | ISD | |
0018004428 | ISD | 00180044 | 00180044 | US & Canada [ISD] | 00180000 | 00180099 | ISD | |
0018004428 | ISD | 00180044 | 00180044 | UK | 00440000 | 00449999 | ISD | |
0018004428 | ISD | 00180044 | 00180044 | |||||
00440140325 | ISD | 00440140 | 00440140 |
Please help,
Regards,
Sandeep Joshi
Hi,
It looks like that this question is regarding modeling so, you should ask it in an appropriate thread.
Kind Regards,
Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.