Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
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
Solved! Go to Solution.
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")
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")
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?
Proud to be a Super User! | |
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
I would also suggest you to create a Date Dim Table
Design guidance for date tables in Power BI Desktop - Power BI | Microsoft Learn
Proud to be a Super User! | |
Can you create a measure instead witht the same DAX?
Proud to be a Super User! | |
Works like a charm! thank you for the quick help
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.
which dax ? with your dax ?
Create a Calculated Column:
DateRange =
VAR StartDate = MIN('YourTable'[Date])
VAR EndDate = MAX('YourTable'[Date])
RETURN StartDate & " - " & EndDate
Proud to be a Super User! | |
Wonderful! but that is returing all the values in my list not the current selection.anyh thoughts please
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.