Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
106 | |
86 | |
81 | |
74 | |
71 |
User | Count |
---|---|
112 | |
101 | |
96 | |
74 | |
67 |