Forum Discussion

Trist's avatar
Trist
Frequent Visitor
5 years ago
Solved

take data from another table

Hi Everybody, How are you?  ı am new at power bi and have question. ı am waiting for your helps. ----------------------------- question: dımensıon table ıd first_date last_date numbers ...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, Trist 

    Please try to create the mode like below, and write the calculated measure like below.

    Please check the sample pbix file, link down below.

     

     

    Find Numbers =
    CALCULATE (
    SELECTEDVALUE ( 'dimension table'[numbers] ),
    FILTER (
    'dimension table',
    'dimension table'[last_date] >= SELECTEDVALUE ( 'fact table'[date] )
    && 'dimension table'[first_date] <= SELECTEDVALUE ( 'fact table'[date] )
    )
    )
     
     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    In Table2, write this calculated column formula

    =calculate(sum(table1[numbers]),filter(table1,table1[first_date]<=earlier(table2[date])&&table1[last_date]>=earlier(table2[date])))

    Hope this helps.

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, Trist 

Please try to create the mode like below, and write the calculated measure like below.

Please check the sample pbix file, link down below.

 

 

Find Numbers =
CALCULATE (
SELECTEDVALUE ( 'dimension table'[numbers] ),
FILTER (
'dimension table',
'dimension table'[last_date] >= SELECTEDVALUE ( 'fact table'[date] )
&& 'dimension table'[first_date] <= SELECTEDVALUE ( 'fact table'[date] )
)
)
 
 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster.