Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I'm having a really hard time with fromdate / todate. I have a table that I created and a month-year slicer.
The month-year slicer should return any data within the selected month that falls between the from and to dates. The month-year slicer is connected to a DATES table that has an active relationship from 'DATES'[date] to 'TABLE1'[fromdate] and an inactive relationship to to 'TABLE1'[todate]. Currently, when I select May 2024, it only pulls in May dates in the fromdate column as a test.
Solved! Go to Solution.
@dw0012 Often the easiest way to do this is to use 2 disconnected date tables. You can then use a measure like this:
Measure =
VAR __FromDate = MAX( 'FromDates'[Date] )
VAR __ToDate = MAX( 'ToDates'[Date] )
VAR __Result = SUMX( FILTER( 'Table', [Date] >= __FromDate && [Date] <= __ToDate ), [Value] )
RETURN
__Result
If that doesn't work, please provide more information. Also, you can watch this for more information on this kind of scenario:
@dw0012 Often the easiest way to do this is to use 2 disconnected date tables. You can then use a measure like this:
Measure =
VAR __FromDate = MAX( 'FromDates'[Date] )
VAR __ToDate = MAX( 'ToDates'[Date] )
VAR __Result = SUMX( FILTER( 'Table', [Date] >= __FromDate && [Date] <= __ToDate ), [Value] )
RETURN
__Result
If that doesn't work, please provide more information. Also, you can watch this for more information on this kind of scenario:
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
90 | |
72 | |
69 |
User | Count |
---|---|
232 | |
128 | |
117 | |
82 | |
82 |