Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Trist
Frequent Visitor

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,

 

1 ACCEPTED SOLUTION
v-alq-msft
Community Support
Community Support

Hi, @Trist 

 

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

Source:

a1.png

 

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:

a2.pnga3.png

 

Best Regards

Allan

 

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

View solution in original post

2 REPLIES 2
v-alq-msft
Community Support
Community Support

Hi, @Trist 

 

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

Source:

a1.png

 

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:

a2.pnga3.png

 

Best Regards

Allan

 

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

amitchandak
Super User
Super User

@Trist , You can not create a column based on the slicer. You can create measures based on that.

 

The best is you can use today or date related to today as column

 

New column = Today()

 

In case you want to date associated with the target. You can do crossjoin with years you want and then can follow the below approach to deal with that

https://blog.enterprisedna.co/using-the-crossjoin-function-in-power-bi/

 

Distributing/Allocating the Yearly Target(Convert to Daily Target): Measure ( Daily/YTD): Magic of CLOSINGBALANCEYEAR With TOTALYTD/DATESYTD: https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Yearly-Target-C...

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.