Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hello.
I have the problem - how to get column 3 according to Column 1, 2, and the value column (table is below)
For the locations and names, I have to detect the max value that I will use in further calculations
Not sure can it be done in M Query or DAX?
Thanks
Nice hot greeting from Croatia
Solved! Go to Solution.
HI
please find a solution
HI
please find a solution
Thanks a lot
Sometimes I cant' find so simple solutions
That is why this community is valuable - quick and simple Q&A
You earned coffee from me
Thanks once again
You can create a measure like
Max Value for Location = CALCULATE( MAX('Table'[Value]), ALLEXCEPT('Table', 'Table'[Column1]))
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.