Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

HASONEVALUE Chalenge

Hello Power BI Friends,   I have two tables as below:   Incoming Date, Value 01/01/2018, 100 02/01/2018,0 03/01/2018,150 05/01/2018,200 //note that in this example there isn´t data for April...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    Hi richardmoreno,

     

    To achieve your requirement, merge incoming table and cost table by inner join like below:

     

     

    After merged:

     

     

    Then click close&apply, create a measure using dax like below:

     

     

    Regards,

    Jimmy Tao

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi richardmoreno,

 

To achieve your requirement, merge incoming table and cost table by inner join like below:

 

 

After merged:

 

 

Then click close&apply, create a measure using dax like below:

 

 

Regards,

Jimmy Tao