Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
Hi @LP280388
Try adding a filter() to the formula.
VAR FirstDay =
CALCULATE (
MIN ( 'From Date'[Date] ),
FILTER ( ALLSELECTED ( 'From Date'[Date] ), 1 = 1 )
)
VAR LastDay =
CALCULATE (
MAX ( 'To Date'[Date] ),
FILTER ( ALLSELECTED ( 'From Date'[Date] ), 1 = 1 )
)
Best Regards,
Jay
Hi @LP280388
Try adding a filter() to the formula.
VAR FirstDay =
CALCULATE (
MIN ( 'From Date'[Date] ),
FILTER ( ALLSELECTED ( 'From Date'[Date] ), 1 = 1 )
)
VAR LastDay =
CALCULATE (
MAX ( 'To Date'[Date] ),
FILTER ( ALLSELECTED ( 'From Date'[Date] ), 1 = 1 )
)
Best Regards,
Jay
Thank you very much.
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |