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.
Hi,
I need to bring the value of "Total Dotación" of his respective "Rol" and "UN" in a different column.
example:
if the date of "Fecha"Marzo de 2019, "UN" EIIC and "Rol" ROL GENERAL is 333, I need in a different column the value of Febrero de 2019, 285.
I would greatly appreciate your help.
Solved! Go to Solution.
Hi @treeclauses ,
Yes, we can sum a column and a measure. You could try like this:
Measure 2 =
VAR total =
SUMX ( 'Table', 'Table'[Total Dotación] + [Measure] )
RETURN
DIVIDE ( total, 2 )
If you don't want to do a calculation while the measure is blank, you could try this:
Measure 3 =
VAR total =
SUMX ( 'Table', 'Table'[Total Dotación] + [Measure] )
RETURN
IF ( ISBLANK ( [Measure] ), BLANK (), DIVIDE ( total, 2 ) )
Hi @treeclauses ,
Please try like this:
Date = CALENDAR(MIN('Table'[Fecha]),MAX('Table'[Fecha]))
Measure = CALCULATE(SUM('Table'[Total Dotación]),DATEADD('Date'[Date],-1,MONTH))
And there are many different ways to implement it. You also could reference the videos to have a try.
https://www.youtube.com/watch?v=-xBYtOVyMTs
https://www.youtube.com/watch?v=s4HsdoSTNt4
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
it works! thanks! @v-xuding-msft
now, if i wanna sum the two values, and divide on 2, how can i do it? can i sum a column with a measure?
Hi @treeclauses ,
Yes, we can sum a column and a measure. You could try like this:
Measure 2 =
VAR total =
SUMX ( 'Table', 'Table'[Total Dotación] + [Measure] )
RETURN
DIVIDE ( total, 2 )
If you don't want to do a calculation while the measure is blank, you could try this:
Measure 3 =
VAR total =
SUMX ( 'Table', 'Table'[Total Dotación] + [Measure] )
RETURN
IF ( ISBLANK ( [Measure] ), BLANK (), DIVIDE ( total, 2 ) )
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 |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |