Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
neeHi
I hope some body can help me!
I have 2 tables, one with dates and one with values, they are connected.
I then what to calculate the sum of the last month and insert the value in a column and same value for every row.
So my data could look something like:
Date | Value |
2020-01-01 | 5 |
2020-01-10 | 8 |
2020-01-15 | 88 |
2020-01-20 | 9 |
2020-01-30 | 55 |
2020-02-08 | 654 |
2020-02-18 | 85 |
2020-02-25 | 1 |
The sum of the last month is 740 I would then like to have a new column there is just 740 for every row. Like below
Date | Value | Total |
2020-01-01 | 5 | 740 |
2020-01-10 | 8 | 740 |
2020-01-15 | 88 | 740 |
2020-01-20 | 9 | 740 |
2020-01-30 | 55 | 740 |
2020-02-08 | 654 | 740 |
2020-02-18 | 85 | 740 |
2020-02-25 | 1 | 740 |
Hope some body can help me 🙂
Solved! Go to Solution.
@Snip , Create a new column as
Column = sumx(FILTER('Table',EOMONTH([date],0) =EOMONTH(max([Date]),0)),[Value])
Hi @Snip ,
Please try this:
Measure =
VAR mon_ =
CALCULATE ( MAX ( 'Table'[Date] ), ALLSELECTED ( 'Table' ) )
RETURN
CALCULATE (
SUM ( 'Table'[Value] ),
FILTER (
ALL ( 'Date' ),
'Date'[Month] = MONTH ( mon_ )
&& MAX ( 'Table'[Value] ) <> BLANK ()
)
)
Hi @Snip ,
Please try this:
Measure =
VAR mon_ =
CALCULATE ( MAX ( 'Table'[Date] ), ALLSELECTED ( 'Table' ) )
RETURN
CALCULATE (
SUM ( 'Table'[Value] ),
FILTER (
ALL ( 'Date' ),
'Date'[Month] = MONTH ( mon_ )
&& MAX ( 'Table'[Value] ) <> BLANK ()
)
)
@Snip , Create a new column as
Column = sumx(FILTER('Table',EOMONTH([date],0) =EOMONTH(max([Date]),0)),[Value])
It do not work. Can you maybe explain what it does?
Remeber i have a date table and a table with the values.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |