showing date as range in the table

[jostnachs]

Hi All I have a requirement to show my date column as a range in a table instead of single date. how can I do that?

any help please

[Laxmanjatoth]

Please see the screenshot above for further clarification. The task is simple: Create a single DAX measure that combines the dates into a range, then drop that measure into the table visual. That's it!"

Date_Range_Measure =
VAR MinDate = MIN('YourTable'[StartDate])
VAR MaxDate = MAX('YourTable'[EndDate])
RETURN
FORMAT(MinDate, "yyyy-mm-dd") & " - " & FORMAT(MaxDate, "yyyy-mm-dd")

[Laxmanjatoth]

Hey man , 

Please see the screenshot above for further clarification. The task is simple: Create a single DAX measure that combines the dates into a range, then drop that measure into the table visual. That's it!",please consider if my req is reached ,otherwise let me know .

Date_Range_Measure =
VAR MinDate = MIN('YourTable'[StartDate])
VAR MaxDate = MAX('YourTable'[EndDate])
RETURN
FORMAT(MinDate, "yyyy-mm-dd") & " - " & FORMAT(MaxDate, "yyyy-mm-dd")

[Kaviraj11]

I'm getting the expected output - , do you have relationship created with a date or calendar table, which date column are you using in the between slicer?

[jostnachs]

effective date is my date slicer which is in V_DimPolicy and i created calculated column in the same table. I am using all the fields from the same table in the table visual as well. The formula is a sbelow

[Kaviraj11]

I would also suggest you to create a Date Dim Table 

Design guidance for date tables in Power BI Desktop - Power BI | Microsoft Learn

[Kaviraj11]

Can you create a measure instead witht the same DAX?

[jostnachs · Accepted solution]

Works like a charm! thank you for the quick help 

[Laxmanjatoth]

hey ,

its not working 

We build this measure since we are unable to accomplish this in direct tables, and it is causing errors when we create the tables. 

[Laxmanjatoth]

which dax ? with your dax ?

[Kaviraj11]

Create a Calculated Column: 

DateRange = 
VAR StartDate = MIN('YourTable'[Date])
VAR EndDate = MAX('YourTable'[Date])
RETURN StartDate & " - " & EndDate

[jostnachs]

Wonderful! but that is returing all the values in my list not the current selection.anyh thoughts please