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.
c1 | c2 | c3 |
may 2020 | 32 | 32 |
jun 2020 | 22 | 54 |
jul 2020 | 54 | |
aug 2020 | 54 | |
sept 2020 | 34 | 88 |
oct 2020 | 2 | 90 |
nov 2020 | ||
dec 2020 |
I have c2 column and need to display c3 running total but blank values before last value should display previous values
my table is connected to date table
my measure:
but displaying cumulative till last
Solved! Go to Solution.
@vijaykumarj19 assume c1 from date table then try this code
=var _currentYM=max(datetable[year month]) return calculate(sum(c2),datetable[year month]<=_currentYM)
Its not showing cumulative count
My table
calculating cumulative and ploted in line graph
Below line should stop at a6
Dax :
can anyone help me with the solution
Need to show a3 and a4 with a2 value
If we have dates as axis
If i have month year from date table as axis then
and i do have a relation between tables
Then how would this dax modified
var c = MAX('Table'[c1])
VAR d = MAXX(FILTER(ALL('Table'),'Table'[c2]>0),'Table'[c1])
Return
IF(c<=d,
CALCULATE(SUM('Table'[c2]),FILTER(ALL('Table'),'Table'[c1]<=c)))
AccTotalc2 = VAR vCurrentDate=MAX(DateTable[Date]) VAR vMaxDate=CALCULATE(MAX('Fact'[c1]),FILTER(ALL('Fact'),'Fact'[c2]>0)) RETURN IF(vCurrentDate<=vMaxDate,CALCULATE(SUM('Fact'[c2]),DateTable[Date]<=vCurrentDate))
AccTotalc4 = VAR vCurrentDate=MAX(DateTable[Date]) VAR vMaxDate=CALCULATE(MAX('Fact'[c1]),FILTER(ALL('Fact'),'Fact'[c4]>0)) RETURN IF(vCurrentDate<=vMaxDate,CALCULATE(SUM('Fact'[c4]),DateTable[Date]<=vCurrentDate))
But it stoped at dec need to be extended till Jan , Because we have value for Jan also
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 |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |