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:
User | Count |
---|---|
85 | |
77 | |
72 | |
70 | |
55 |
User | Count |
---|---|
106 | |
96 | |
90 | |
79 | |
68 |