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
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
Super User

@UlisesCiccola , Try a measure like

 

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

amitchandak
Super User
Super User

@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

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
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