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.
Solved! Go to Solution.
Hey,
I'm not sure if I understand you requirements 100%, but as a 1st attempt I recommend to rewrite your existing measure a little:
LeaseFirmDate 2-3 months ago = var Date1 = DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), DAY ( TODAY () ) - 60 ) var Date2 = DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), DAY ( TODAY () ) - 90 ) var t = FILTER( Lease, Lease[LeaseFirmDate] < Date1 && Lease[LeaseFirmDate] > Date2 ) return SUMX( t ,Lease[Leases Count] )
if this does not work, can you please provide a pbix that contains sample data and represents your data model. Upload the file to onedrive or dropbox and share the link.
Regards,
Tom
Hey,
I'm not sure if I understand you requirements 100%, but as a 1st attempt I recommend to rewrite your existing measure a little:
LeaseFirmDate 2-3 months ago = var Date1 = DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), DAY ( TODAY () ) - 60 ) var Date2 = DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), DAY ( TODAY () ) - 90 ) var t = FILTER( Lease, Lease[LeaseFirmDate] < Date1 && Lease[LeaseFirmDate] > Date2 ) return SUMX( t ,Lease[Leases Count] )
if this does not work, can you please provide a pbix that contains sample data and represents your data model. Upload the file to onedrive or dropbox and share the link.
Regards,
Tom
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |