Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am using the below DAX code:
Solved! Go to Solution.
@sandip , try like
CALENDAR(minx(TBL_Date,TBL_Date[Start Time]),maxx(TBL_Date,TBL_Date[End Time]))
or
CALENDAR(minx(TBL_Date,[Start Time]),maxx(TBL_Date,[End Time]))
Hi @sandip ,
The range of dates is from the specified start date to the specified end date, inclusive of those two dates. You write two columns in the calendar function rather than two dates.
The formulas that @amitchandak suggests should work perfectly. Or you could just write like this:
TBL_Calendar =
CALENDAR ( MIN ( TBL_Date[Start Time] ), MAX ( TBL_Date[End Time] ) )
Creating Calendar Table in Power BI using DAX Functions
@sandip , try like
CALENDAR(minx(TBL_Date,TBL_Date[Start Time]),maxx(TBL_Date,TBL_Date[End Time]))
or
CALENDAR(minx(TBL_Date,[Start Time]),maxx(TBL_Date,[End Time]))
Hi,
Actually your second expression works well for me like below:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |