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
olives
Helper I
Helper I

Calculate achievement rate based on the criterion of up to today.

Hi

I am trying to calculate the percentage of sales achieved rate, but I do not want to calculate for future days.


I have three tables: sales, goals, and calendar.
The sales date in sales and the target date in goals are related to the calendar date.
The formula to calculate the percentage of sales achieved is written like this.

 
Achieved rate= DIVIDE([Sales],[Goal])

  I appreciate any help.

1 ACCEPTED SOLUTION
wdx223_Daniel
Super User
Super User

cacculate(divide(),keepfilters(calendar[date]<=today()))

View solution in original post

2 REPLIES 2
wdx223_Daniel
Super User
Super User

cacculate(divide(),keepfilters(calendar[date]<=today()))

It worked!!

Thank you so much😅

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