We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
Hi folks , I have one table with these columns .
Closed | Closed things Cumulative Closed things
20/4/2018 | 2 | 2
22/4/2018 | 2 | 4
25/4/2018 | 5 | 9
'Actual opened things'
*THIS IS THE COLUMN I WANT TO CALCULATE
Which I want to be a Cumulative column which subtracts with the 'cumulative Closed things' only if
it has values on that date.*
Opened | Opened things | Cumulative Open things | Actual opened things
15/4/2018 | 10 | 0+10=10 | 10-0=0
17/4/2018 | 6 | 10+6=16 | 16-0=16
21/4/2018 | 9 | 16+9=25 | 25-2=23
26/4/2018 | 11 | 25+11=36 | 36-9=27
I want to see in each date how many things are opened , with that being said I want for each date Cumulative Open Things - Cumulative Closed Things (only if it has closed things on before that date )
Appreciate any help on Dax or something like that .
Thanks guys. Anything you don't understand please let me know .
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 |