cancel
Showing results for
Did you mean:
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
Super User IV

@UlisesCiccola , Try a measure like

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

Proud to be a Super User!

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

Proud to be a Super User!

Helper I

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

Announcements