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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors