Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Lookupvalue or an other formula to search a value with a measure ?

Hello / Good morning,

 

My question is very sample. I own a table result which contain several column . Each column come from to a column or a measure.

 

In my case I own a result from measure . If the result = 1 , I want process to a "lookupvalue" with column and measure parameters.

 

My formula that I want complete :

 

My_value_wanted =
var okay= [Measure_okay]
return
if([Measure_okay]=1; condition true > lookupvalue ; condition false > keep empty )

 

Sans titre.png

 

blue : column text format

red : measure result date format

 

My key to search in an other table :  'mytable'[offer_code]&"_"&'mytable'[offer_state]&"_"&value([Date_from_measure_result])

 

In a second table if value exist return a key and associeted value .

 

I must use lookupvalue or fitler system ?

 

Thanks for the help.

 

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hello,

 

After severals hours to search a solution, I have tried this formula :

 

step 1 :

 

key_borne max =
var affiche = [M_affichable]
var valnum=value([M_Date Max garde])
return
if(affiche=1;maxx(bi2n_dmt_rec;bi2n_dmt_rec[offer_code]&"_"&bi2n_dmt_rec[offer_state]&"_"&[M_Date Max garde]);"")
 
step 2 :
 
recherche parc fin =
var valsearch = [key_borne max]
return
LOOKUPVALUE(T_union_decale_current[state_park_current_day];T_union_decale_current[key_offercode_state_date];valsearch)

 

View solution in original post

2 REPLIES 2
v-diye-msft
Community Support
Community Support

Hi @Anonymous 

 

You might consider creating pbix file that will contain some sample data, upload the pbix to onedrive or dropbox and share the link to the file. Please do not forget to describe the expected results based on this sample data.

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
Anonymous
Not applicable

Hello,

 

After severals hours to search a solution, I have tried this formula :

 

step 1 :

 

key_borne max =
var affiche = [M_affichable]
var valnum=value([M_Date Max garde])
return
if(affiche=1;maxx(bi2n_dmt_rec;bi2n_dmt_rec[offer_code]&"_"&bi2n_dmt_rec[offer_state]&"_"&[M_Date Max garde]);"")
 
step 2 :
 
recherche parc fin =
var valsearch = [key_borne max]
return
LOOKUPVALUE(T_union_decale_current[state_park_current_day];T_union_decale_current[key_offercode_state_date];valsearch)

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.