cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
UlisesCiccola
Helper I
Helper I

Calculate measure with fixed value

Hello everyone,

 

 

I am quite new to DAX and need to obtain a calculated measure based on the following data. The column "Total days in Month" has the sum of the column "difference" for a given month. This date table is connected to a sales table by the date column: 

 

Date               Value             Difference     Total days in Month

  

25/6/2011     21.7                  0                       25.7

26/6/2011     21.7                   0                     25.7

27/6/2011     22.7                  1                      25.7

28/6/2011     23.7                  1                     25.7

29/6/2011     24.7                  1                     25.7

30/6/2011     25.7                  1                     25.7

1/07/2011       1                    1                      25.4

2/07/2011       2                    1                     25.4

3/07/2011       2.7                0.7                   25.4

 

I need to calculate the sum of sales/fixed value for the month. For instance if I pick june I need to have the sum of sales divided by 25.7 but if I pick just one day of july the denominator will be the sum of 25.7 and 25.4

 

Thank you so much in advance!!!

3 REPLIES 3
amitchandak
Super User IV
Super User IV

@UlisesCiccola , Try a measure like

 

closingbalancemonth(Table[Date],sum(Table[Value]))



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

amitchandak
Super User IV
Super User IV

@UlisesCiccola , is it value of the last date of the month, you can use closingbalancemonth

https://docs.microsoft.com/en-us/dax/closingbalancemonth-function-dax



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

I am sorry, never used this DAX, how would I use it in this context considering the table given? Also the final value for the month changes each month.

 

Sorry for the question by I am quite new to Dax and need the answer for this particular problem

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

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

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors