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
See attached the following screenshot.
The information is from 2 tables:
Table 1 - Generation:
IntervalStart
IntervalValue
Table 2 - NIM:
NMI
UOM
RegisterID
I would like to put a formula in that says:
IF RegisterID = "E1", then make the corresponding IntervalValue date negative by multiplying by -1
I also would like to consolidate or SUM where data in NMI column is = "7102000057", "7102000058", & "7102000059",
Thanks
Solved! Go to Solution.
Hi @wvdmpowerbi ,
IF RegisterID = "E1", then make the corresponding IntervalValue date negative by multiplying by -1
To create a calculated column as below.
Column = IF('Table'[RegisterID]="E1",'Table'[IntervalValue]*-1)
I also would like to consolidate or SUM where data in NMI column is = "7102000057", "7102000058", & "7102000059",
For the request, what did you want? A measure of a calculated table?
Measure:
Measure = CALCULATE(SUM('Table'[Column]),FILTER('Table','Table'[NIMI]=7102000057 || 'Table'[NIMI]=7102000058 || 'Table'[NIMI]=7102000059))
Table:
filter table = FILTER('Table','Table'[NIMI]=7102000057 || 'Table'[NIMI]=7102000058 || 'Table'[NIMI]=7102000059)
If it doesn't meet your requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
BTW, Pbix as attached.
Hi @wvdmpowerbi ,
IF RegisterID = "E1", then make the corresponding IntervalValue date negative by multiplying by -1
To create a calculated column as below.
Column = IF('Table'[RegisterID]="E1",'Table'[IntervalValue]*-1)
I also would like to consolidate or SUM where data in NMI column is = "7102000057", "7102000058", & "7102000059",
For the request, what did you want? A measure of a calculated table?
Measure:
Measure = CALCULATE(SUM('Table'[Column]),FILTER('Table','Table'[NIMI]=7102000057 || 'Table'[NIMI]=7102000058 || 'Table'[NIMI]=7102000059))
Table:
filter table = FILTER('Table','Table'[NIMI]=7102000057 || 'Table'[NIMI]=7102000058 || 'Table'[NIMI]=7102000059)
If it doesn't meet your requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
BTW, Pbix as attached.
Hi @wvdmpowerbi
Can you provide a useable sample?
How do i attach a same file?
Hi @wvdmedify
Please see the below.
I dont have that access, any other method?
@Mariusz wrote:Hi @wvdmedify
Please see the below.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
7102000057 | 30/06/2019 0:15 | 3 | kWh | E1 |
7102000058 | 30/06/2019 0:15 | 4 | kWh | E1 |
7102000059 | 30/06/2019 0:15 | 1.39 | kWh | E1 |
7102000057 | 30/06/2019 0:30 | 4 | kWh | E1 |
7102000058 | 30/06/2019 0:30 | 4 | kWh | E1 |
7102000059 | 30/06/2019 0:30 | 1.39 | kWh | E1 |
7102000057 | 30/06/2019 0:45 | 3 | kWh | E1 |
7102000058 | 30/06/2019 0:45 | 5 | kWh | E1 |
7102000059 | 30/06/2019 0:45 | 1.42 | kWh | E1 |
7102000057 | 30/06/2019 1:00 | 3 | kWh | E1 |
7102000058 | 30/06/2019 1:00 | 4 | kWh | E1 |
7102000059 | 30/06/2019 1:00 | 1.41 | kWh | E1 |
7102000057 | 30/06/2019 1:15 | 4 | kWh | E1 |
7102000058 | 30/06/2019 1:15 | 4 | kWh | E1 |
7102000059 | 30/06/2019 1:15 | 1.42 | kWh | E1 |
7102000057 | 30/06/2019 1:30 | 3 | kWh | E1 |
7102000058 | 30/06/2019 1:30 | 5 | kWh | E1 |
7102000059 | 30/06/2019 1:30 | 1.44 | kWh | E1 |
7102000057 | 30/06/2019 1:45 | 4 | kWh | E1 |
7102000058 | 30/06/2019 1:45 | 4 | kWh | E1 |
7102000059 | 30/06/2019 1:45 | 1.41 | kWh | E1 |
7102000057 | 30/06/2019 2:00 | 3 | kWh | E1 |
7102000058 | 30/06/2019 2:00 | 5 | kWh | E1 |
7102000059 | 30/06/2019 2:00 | 1.41 | kWh | E1 |
7102000057 | 30/06/2019 2:15 | 3 | kWh | E1 |
7102000058 | 30/06/2019 2:15 | 4 | kWh | E1 |
7102000059 | 30/06/2019 2:15 | 1.4 | kWh | E1 |
7102000057 | 30/06/2019 2:30 | 4 | kWh | E1 |
7102000058 | 30/06/2019 2:30 | 4 | kWh | E1 |
7102000059 | 30/06/2019 2:30 | 1.4 | kWh | E1 |
7102000057 | 30/06/2019 2:45 | 3 | kWh | E1 |
7102000058 | 30/06/2019 2:45 | 5 | kWh | E1 |
7102000059 | 30/06/2019 2:45 | 1.41 | kWh | E1 |
7102000057 | 30/06/2019 3:00 | 4 | kWh | E1 |
7102000058 | 30/06/2019 3:00 | 4 | kWh | E1 |
7102000059 | 30/06/2019 3:00 | 1.46 | kWh | E1 |
7102000057 | 30/06/2019 3:15 | 3 | kWh | E1 |
7102000058 | 30/06/2019 3:15 | 5 | kWh | E1 |
7102000059 | 30/06/2019 3:15 | 1.43 | kWh | E1 |
7102000057 | 30/06/2019 3:30 | 4 | kWh | E1 |
7102000058 | 30/06/2019 3:30 | 4 | kWh | E1 |
7102000059 | 30/06/2019 3:30 | 1.39 | kWh | E1 |
7102000057 | 30/06/2019 3:45 | 3 | kWh | E1 |
7102000058 | 30/06/2019 3:45 | 5 | kWh | E1 |
7102000059 | 30/06/2019 3:45 | 1.44 | kWh | E1 |
7102000057 | 30/06/2019 4:00 | 4 | kWh | E1 |
7102000058 | 30/06/2019 4:00 | 4 | kWh | E1 |
7102000059 | 30/06/2019 4:00 | 1.39 | kWh | E1 |
7102000057 | 30/06/2019 4:15 | 3 | kWh | E1 |
7102000058 | 30/06/2019 4:15 | 5 | kWh | E1 |
7102000059 | 30/06/2019 4:15 | 1.4 | kWh | E1 |
7102000057 | 30/06/2019 4:30 | 4 | kWh | E1 |
7102000058 | 30/06/2019 4:30 | 4 | kWh | E1 |
7102000059 | 30/06/2019 4:30 | 1.43 | kWh | E1 |
7102000057 | 30/06/2019 4:45 | 3 | kWh | E1 |
7102000058 | 30/06/2019 4:45 | 4 | kWh | E1 |
7102000059 | 30/06/2019 4:45 | 1.43 | kWh | E1 |
7102000057 | 30/06/2019 5:00 | 4 | kWh | E1 |
7102000058 | 30/06/2019 5:00 | 5 | kWh | E1 |
7102000059 | 30/06/2019 5:00 | 1.53 | kWh | E1 |
7102000057 | 30/06/2019 5:15 | 3 | kWh | E1 |
7102000058 | 30/06/2019 5:15 | 4 | kWh | E1 |
7102000059 | 30/06/2019 5:15 | 1.45 | kWh | E1 |
7102000057 | 30/06/2019 5:30 | 3 | kWh | E1 |
7102000058 | 30/06/2019 5:30 | 5 | kWh | E1 |
7102000059 | 30/06/2019 5:30 | 1.41 | kWh | E1 |
7102000057 | 30/06/2019 5:45 | 4 | kWh | E1 |
7102000058 | 30/06/2019 5:45 | 4 | kWh | E1 |
7102000059 | 30/06/2019 5:45 | 1.43 | kWh | E1 |
7102000057 | 30/06/2019 6:00 | 3 | kWh | E1 |
7102000058 | 30/06/2019 6:00 | 4 | kWh | E1 |
7102000059 | 30/06/2019 6:00 | 1.41 | kWh | E1 |
7102000057 | 30/06/2019 6:15 | 4 | kWh | E1 |
7102000058 | 30/06/2019 6:15 | 5 | kWh | E1 |
7102000059 | 30/06/2019 6:15 | 1.46 | kWh | E1 |
7102000057 | 30/06/2019 6:30 | 3 | kWh | E1 |
7102000058 | 30/06/2019 6:30 | 4 | kWh | E1 |
7102000059 | 30/06/2019 6:30 | 1.44 | kWh | E1 |
7102000057 | 30/06/2019 6:45 | 4 | kWh | E1 |
7102000058 | 30/06/2019 6:45 | 5 | kWh | E1 |
7102000059 | 30/06/2019 6:45 | 1.91 | kWh | E1 |
7102000057 | 30/06/2019 7:00 | 3 | kWh | E1 |
7102000058 | 30/06/2019 7:00 | 4 | kWh | E1 |
7102000059 | 30/06/2019 7:00 | 1.47 | kWh | E1 |
7102000057 | 30/06/2019 7:15 | 5 | kWh | E1 |
7102000058 | 30/06/2019 7:15 | 6 | kWh | E1 |
7102000059 | 30/06/2019 7:15 | 1.42 | kWh | E1 |
7102000057 | 30/06/2019 7:30 | 25 | kWh | B1 |
7102000058 | 30/06/2019 7:30 | 31 | kWh | B1 |
7102000059 | 30/06/2019 7:30 | 1.42 | kWh | E1 |
7102000057 | 30/06/2019 7:45 | 114 | kWh | B1 |
7102000058 | 30/06/2019 7:45 | 137 | kWh | B1 |
7102000059 | 30/06/2019 7:45 | 1.38 | kWh | E1 |
7102000057 | 30/06/2019 8:00 | 419 | kWh | B1 |
7102000058 | 30/06/2019 8:00 | 505 | kWh | B1 |
7102000059 | 30/06/2019 8:00 | 1.41 | kWh | E1 |
7102000057 | 30/06/2019 8:15 | 1029 | kWh | B1 |
7102000058 | 30/06/2019 8:15 | 1235 | kWh | B1 |
7102000059 | 30/06/2019 8:15 | 1.39 | kWh | E1 |
7102000057 | 30/06/2019 8:30 | 1737 | kWh | B1 |
7102000058 | 30/06/2019 8:30 | 2085 | kWh | B1 |
7102000059 | 30/06/2019 8:30 | 1.43 | kWh | E1 |
7102000057 | 30/06/2019 8:45 | 2472 | kWh | B1 |
7102000058 | 30/06/2019 8:45 | 2968 | kWh | B1 |
7102000059 | 30/06/2019 8:45 | 1.41 | kWh | E1 |
Thanks Maruisz
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.