Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All. Relatively new to PowerBi and need some help for this transformation in PowerQuery. Thought it best to make a diagram rather than type a huge essay to explain what I am trying to achieve ! I am basically trying to calculate profit / loss on transactions that have been made over a period of time. The profit/loss needs to be made/posted when the final sale has happened. I hope this makes some sense. Thanks.
Solved! Go to Solution.
M and DAX are different. you need to close the power query editor and click the new column button which is under the modeling tab.
Proud to be a Super User!
I think you can use DAX to create a new column
Column = CALCULATE(MAX('Table'[TRADE DATE]),ALLEXCEPT('Table','Table'[CODE]))
Proud to be a Super User!
Hi Ryan,
Many thanks for your help. Appologies for my delayed response. I have tried numerous versions of below but seem to hit errors. Probably my lack of M programming/syntax. TRAN TABLE is the name of the table I generate in the query. Am trying to use the exact sytac you have provided but when using fully quallified name for table & column it suggests I put in " "...any advise appreciated. Thanks
M and DAX are different. you need to close the power query editor and click the new column button which is under the modeling tab.
Proud to be a Super User!
Hi Ryan.
Thanks very much for the help AND explaining the M versue PQ - fundamental.
😀
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |