Forum Discussion

New2PowerBI's avatar
New2PowerBI
Helper III
9 years ago
Solved

IF Statement Help

I'm new to Power BI and would like some help.  I have a table with values: FREQUENCY (with numerical values) and FREQUENCY UNITS (with alphanumeric values) I have another table that provides a "ke...
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi New2PowerBI,

     

    In your scenario, please add a calculated column in the table(in my test, it's named 'Fact Table') which contains thousands of records using below DAX formula:

     

    KEY =
LOOKUPVALUE (
    'Key Table'[Annual WO Impact],
    'Key Table'[FREQUENCY], 'Fact Table'[FREQUENCY],
    'Key Table'[FREQUNIT], 'Fact Table'[FREQUNIT]
)

    Thanks,
    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi New2PowerBI,

 

In your scenario, please add a calculated column in the table(in my test, it's named 'Fact Table') which contains thousands of records using below DAX formula:

 

KEY =
LOOKUPVALUE (
    'Key Table'[Annual WO Impact],
    'Key Table'[FREQUENCY], 'Fact Table'[FREQUENCY],
    'Key Table'[FREQUNIT], 'Fact Table'[FREQUNIT]
)

Thanks,
Yuliana Gu

New2PowerBI's avatar
New2PowerBI
Helper III
9 years ago

Thank You!!!  Worked like a charm!  I have a lot of similar scenarios; I'll be able to apply this to more than just one problem.  Thanks again!!