Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Regular Visitor

Look Back

I am trying to get my data so on the first of the month, it looks back for any entry in a particular column "Points".  I need it to check and if there are no entries for the prevoius two calendar months return a value of -1.  Then I need it to wait two months and do it again, and so on for 12 months.  If when it looks back and finds an entry, I need the process to start all over again.  Each two months with no entry will render a -1 until it reachs 0.  


Basically, two months with no entry is reward of -1.  if it goes anther two months with no entry another reward of -1.  etc.  The Point will be deducted from a twelve month total until it hits zero.  It can't go below zero.  No negative total.


I figure I will need to have the twelve month total - the reward column = total points but total points can't ever be a negative number.  


I'm new to BI so I'm not great at coding.  Any help would be appreciated.




Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors