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
sajal161292
Helper V
Helper V

Need to select date of a particular cell

Hi,

 

I have this requirement of selecting the date for the cell where there is negative quantity and then perform further computation upon it 

I m using a matrix visual for representing my data in power bi.Capture11.PNG

 

As an example in the screenshot above i need to get the date for which negative quantity starts appearing i.e 3/30/2018 in this case.

2 REPLIES 2
Greg_Deckler
Super User
Super User

What are you using for the Values field? Seems like you could do a simple IF statement for <0 and then do you further computations.

 

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Hi,

 

Please find my sceenshot below:

 

Capture12.PNG

There exists a Many to One relationship between the Shortages and Calendar;Shortages and ItemInfo.

Shortages is being derived from the table ShortageData.

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.