Forum Discussion
Dax
Hey Syndicate_Admin ,
please take the time and create a Power BI Desktop file that contains sample data but still reflects your data model by using the manual input method in Power BI desktop. Upload the file to onedrive or dropbox and share the link. If you are using Excel to create the sample data share the xlsx as well.
I do not understand the rule to multiply the enegy consumption of client1 on the 1st of January 2021 as there are three factors in table that have client 1, the same data, namely the 1st of January 2021. From the expected result, it seems the factor of residential has been used to calcualte the energy consumption. This is the rule that I do not understand.
On the 2nd of January the energy consumption is 480 how has this been calculated and what is the rule behind this calculation.
Regards,
Tom
Hello Thank you very much for answering in effect to calculate the energy consumption by segment of a customer you have to have the total of the energy consumed in a month, after this total you have to multiply by the factor of the segment of that Month to obtain the amount per segment of that customer
https://drive.google.com/drive/folders/1h0doE4AFUqXs3BpVmqSP43e9wot1T7wq?usp=sharing
attached the link where the test pbi file is equantered I hope you can enter thanks in advance