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, I am going crazy?! 3 secs in Excel, 2 hrs in PowerBI......
I am simply trying to multiply 1 column by a percentage value from another column, using the quick measure button.... I have tried using MAX and Sumx etc..... This should be like instant, what I am missing/doing wrong?
Hi @Anonymous
We are all here to help you, so please don't be too anxious.
What is the relationship between the two tables?
Best Regards
Maggie
HI, I am a Dax M language type of person, but am able to steal and amend a few calcs here and there......This seems very complicated.....However, I do not a have grasp as an MS Access user of uniqueness and row level joins etc...... I am guessing/assuming that the column data is not tight enough, so are the rows mis-joining and not aligning properly, so rogue values are being grouped intra row? Do I need to create a calculated column and concat a load of col values to force a stronger "perfect" unique join and then apply the calc? I know thats not Dax'style or purist, as I am just looking for a dirty workaround that works that I can understand as a none programmer....? 😞...... I also get confused as to whether its better to create new tables at transfomration stage and rejoin them than apply measures after the event...... i.e. receive data, break it down into logical chunks, then glue it back together using keys etc.....(a bit like I am suggesting above?)....
Hi @Anonymous
Firstly learn some basic techniques:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-quickstart-learn-dax-basics
https://docs.microsoft.com/en-us/dax/dax-overview
Later i would create a simple example to help you understand your problem.
Best Regards
Maggie
Hi, I just hit a wall with this? I though max was the usual one too.....
@Anonymous , You need have common group by or dimension where you can group this data and multiply
Like
Sumx(summarize(Dimension,Dimension[Dim],"_1",sum(MergeData[EAC]) , "_2",sum(BasecaseRpiX[Percent Indextaion])),[_1]*[_2])
Refer, how I have taken advantage order dim to take date diff
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.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |