Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
Anonymous
Not applicable

Returning 0 if earliest date if not in the last quarter

Hi Community,

 

I have a table where I have few dates associated with an account. I have created a waterfall chart to evaluate the performance
within last two quarters.

 

I want to create a measure where I want to filter out those accounts where it started within the last quarter.


The measure should take the earliest date among all the dates related with that particular account and
check whether it is within the last quarter or not. If not, it should return 0 for that account.

 

I have the data as follows.

 

NOTE: I have few accounts that are blank, but also that has a date.

 

Feature_1Account_NameDate
abc 31-01-2018
bacAA01-01-2018
cabBB06-01-2019
epoBB07-01-2019
pacCC04-10-2020
mjhSP05-10-2020

 


Please help with the DAX.  Thanks

1 REPLY 1
dedelman_clng
Community Champion
Community Champion

Hi @Anonymous  - 

 

What is your expected result given this data set? It would be easier for us to help if you provided a copy of your report with sensitive data scrubbed out.  See How-to-Get-Your-Question-Answered-Quickly  for more tips on how best to present your problem in the forums.

 

 

David

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors