The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello everyone,
I have a problem with the creation of a chart.
The data I have are as follows:
- Part number = a set of unique code
- Created Date= date of creation of the code
- Modified Date = date of modified of the code
- Outcome= the code is active or not (True/False)
I have to create a waterfall chart where I have by month the active codes minus the subtraction of those no longer active in that month (using the modified date).
I got the following chart using these formulas:
- controllo = if(AND(Registry[ToControl]=false, Registry[Created].[Date]<>Registry[Modified]),1,0) --> creation of a new column with a binary output
- Quanti meno = -(DISTINCTCOUNT(Registry[PartNumber])-sum(Registry[controllo])) --> creation of a measure by month
But in this chart I can't insert the progressive substraction, so I would to see by month the earlier number of code minus the code that are no longer active. Any suggestion?
Thank you!
Hi, thank you it works!!
Hi,
I insert an example of data.
Created | PartNumber | Outcome | Modified |
28/03/2022 10:45 | A1801 | TRUE | 29/03/2022 05:57 |
28/03/2022 10:45 | A1802 | TRUE | 29/03/2022 05:58 |
28/03/2022 10:45 | A1803 | TRUE | 29/03/2022 06:04 |
28/03/2022 11:36 | A1804 | TRUE | 29/03/2022 06:23 |
28/03/2022 11:38 | A1810 | TRUE | 29/03/2022 06:22 |
28/03/2022 11:38 | A1811 | TRUE | 29/03/2022 06:22 |
28/03/2022 11:38 | A1812 | TRUE | 29/03/2022 06:22 |
28/03/2022 11:38 | A1813 | TRUE | 29/03/2022 06:22 |
28/03/2022 14:23 | A1814 | FALSE | 28/03/2022 14:23 |
28/03/2022 14:24 | A1815 | FALSE | 28/03/2022 14:24 |
28/03/2022 10:38 | A1816 | FALSE | 08/07/2022 07:57 |
28/03/2022 10:38 | A1817 | FALSE | 08/07/2022 07:57 |
28/03/2022 10:38 | A1818 | FALSE | 08/07/2022 07:57 |
28/03/2022 10:39 | A1819 | FALSE | 08/07/2022 07:57 |
28/03/2022 10:39 | A1820 | FALSE | 07/07/2022 09:48 |
28/03/2022 10:39 | A1821 | FALSE | 07/07/2022 09:48 |
28/03/2022 10:44 | A1822 | FALSE | 27/05/2022 08:18 |
28/03/2022 11:37 | A1823 | FALSE | 08/07/2022 07:50 |
28/03/2022 11:38 | A1824 | FALSE | 08/07/2022 07:50 |
28/03/2022 11:39 | A1825 | FALSE | 08/07/2022 07:50 |
28/03/2022 10:34 | A1842 | TRUE | 28/03/2022 10:34 |
28/03/2022 10:34 | A1843 | TRUE | 28/03/2022 10:34 |
28/03/2022 10:34 | A1844 | TRUE | 28/03/2022 10:34 |
28/03/2022 10:34 | A1845 | TRUE | 28/03/2022 10:34 |
28/03/2022 10:34 | A1846 | TRUE | 28/03/2022 10:34 |
28/03/2022 10:34 | A1847 | TRUE | 28/03/2022 10:34 |
28/03/2022 10:35 | A1848 | TRUE | 28/03/2022 10:35 |
28/03/2022 10:35 | A1849 | TRUE | 28/03/2022 10:35 |
28/03/2022 11:42 | A1850 | TRUE | 28/03/2022 11:42 |
28/03/2022 11:43 | A1851 | TRUE | 28/03/2022 11:43 |
28/03/2022 14:34 | A1852 | FALSE | 28/03/2022 14:34 |
28/03/2022 14:34 | A1853 | FALSE | 28/03/2022 14:34 |
28/03/2022 14:34 | A1854 | FALSE | 28/03/2022 14:34 |
Please indicate the expected outcome. Is this it?
Also note that the seed value (the starting value) is in the same month as some of the reductions - that cannot be shown in the waterfall chart unless you go down to day level.
Please provide sanitized sample data that fully covers your issue. I cannot help you without usable sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. I cannot use screenshots of your source data.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523