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 th...
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.

amitchandak's avatar
amitchandak
Super User
5 years ago

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-Convert-to/ba-p/1476400