Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hey all,
I have my dataset below, Column, Column 2, Column3, Column4 and Measure 2 are calculated columns and measuures i have created. measure should be a commlative of column 2. In the screenshot below var c1 is column1, c2 is column3 and c3 is column2.
thanks!
@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
One change
change the last sumx as
Sumx(Values('Trending in excel'[age at awareness date]), c3)
//5 the last line. rest should be same
and what do you mean by that "//5 the last line. rest should be same"?
i did not understand
thanks!
I change as you said, and now it appears like this:
the sample data from 'Trending in excel':
and from IB pumps:
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |