Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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