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

DoubleJ's avatar
DoubleJ
Solution Supplier
9 years ago

What you could do:

1) In both tables create a key column concatenating the frequency and the unit, delemited by a special character like "_"

Key = [FREQUENCY] & "_" & [FREQUNIT]

 

2) relate the tables by these columns

 

3) because it is an many:1 relationship you can now access the [Annual WO Impact] column as it were in the same table and do your calculations 

 

Hope this helps

JJ

 

 

 

New2PowerBI's avatar
New2PowerBI
Helper III
9 years ago

Thanks for your response!