Forum Discussion

Trist's avatar
Trist
Frequent Visitor
5 years ago
Solved

date ıssue

Hi ,

ı have questıon about brınging selected date to maın table which is customer. 

 ı have date field in date table as - selected date =selectedvalue('DATE'[actualdate])- and what ı wanna do is that when ı select a date from 'DATE'[actualdate] filter it is going to be shown in the source table of maın table  as duplicated in all rows.

for example ı have customer table  when ı select date as 01.01.1991 ı wanna that target data will be as below:

source                  ------->>>>>>>          target                    

cust_ıd,name,age                  |                    cust_ıd,name,age,selecteddate

1,tony,61                               |                   1,tony,61 ,01.01.1991 

2,hony,71                              |                   2,hony,71,01.01.1991

3,pony,81                              |                   3,pony,81,01.01.1991

 

note: there is no relation between tables in logic model.

how can ı do that? if somebody help it will be perfect for me 

thanks,

 

Need Help
Need Info
  • v-alq-msft's avatar
    v-alq-msft
    5 years ago

    Hi, Trist 

     

    Based on your description, i created data to reproduce your scenario. The pbix file is attached in the end.

    Source:

     

    Date(a calculated table):

    Date = 
CALENDAR(
    DATE(2020,1,1),
    DATE(2021,12,31)
)

     

    You may create a measure like below.

    Result = MAX('Date'[ActualDate])

     

    Result:

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies