Inserting a column in to Date Table

[Anonymous]

Hi,

I need to put this logic in to a custom column or any other logical column as a seperate column in to my Date table,

Custom_Date=

VAR minDate =

CALCULATE ( MIN ( DateTable[Date] ) )

VAR maxDate =

CALCULATE ( MAX ( DateTable[Date] ) )

RETURN

IF (

MAX ( DateTable[Date] ) >= minDate

&& MAX ( DateTable[Date] ) <= maxDate,

minDate & " " & maxDate

)

Can anyone help me on this?

Thanks

[Anonymous]

Hi,

I need to put this logic in to a custom column or any other logical column as a seperate column in to my Date table,

Custom_Date=

VAR minDate =

CALCULATE ( MIN ( DateTable[Date] ) )

VAR maxDate =

CALCULATE ( MAX ( DateTable[Date] ) )

RETURN

IF (

MAX ( DateTable[Date] ) >= minDate

&& MAX ( DateTable[Date] ) <= maxDate,

minDate & " " & maxDate

)

Can anyone help me on this?

Thanks

[Fowmy]

@Anonymous 

I am not sure about the usage of this column in a visual but this custom column should give you what you expect:

Custom_Date = 

 VAR _START = MIN(DateTable[Date])
 VAR _CURRENT = [Date]

RETURN
 _START & "  " & _CURRENT 

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Anonymous]

@Fowmy 

I used your formula in custom column.But its shows an error.

[v-easonf-msft]

Hi , @Anonymous 

@Fowmy 's solution could work.

If yes, please accept his reply as solution, so that other community members will easily find the solution when they get the same issue.For now, there is no content of description in the thread. If you still need help, please feel free to ask.

Best Regards,
Community Support Team _ Eason

[Fowmy · Accepted solution]

@Anonymous 

It was supposed to be used in the Data Model using DAX. 
Add in the model date table and check if you get the results.

If you want to add it in Power Query, add below code as a new custom column

=Date.ToText(Date.StartOfYear([Date]),"dd-MMM-yy") &" --- "& Date.ToText( [Date],"dd-MMM-yy")

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[amitchandak]

@Anonymous , what calculation you are looking for. Min and max you are taking in the column calculations are the min-max of the calendar. so you will end up getting

_min & " _ " _max

Appended min and max dates. What you are looking for?

[Anonymous]

@amitchandak 

Im want to get min and max date from the date calendar. I can get the dates using a measure.But i cant put a measure as a category in waterfall chart.I need to use this column as x axis in my water fall chart.So in the chart i want to show only first date of the year and todate.

Above i put my measure loguc and simply i need to use this logic in to a column.I tried calculated column but it didnt work.so i need to use this measure in query editor and use as a custom or conditional column.

Thanks

[amitchandak]

@Anonymous , if you want to show YTD, use datesytd with calendar and slicer

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))
Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))

If you min date of the year you can use

startofyear([Date])  // make sure start of year date is there in calendar else it will take min available date

https://docs.microsoft.com/en-us/dax/startofyear-function-dax