Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi,
I have a DAX question I am looking for some advice on -
I have a simple DAX measure for Total Sales - SUM(Sales[SalesAmount]), in a table with Products like below:
But what I require is a DAX measure that will recognise a duplicate value and add .1 to the duplicated value, so essentially the desirted outcome looks like the below:
Any advice appreciated, thanks in advance.
Solved! Go to Solution.
One can never imagine how funny requests on the forum can be.
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LearnAndPractise(Everyday) ) |
One can never imagine how funny requests on the forum can be.
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LearnAndPractise(Everyday) ) |
Its to handle categorise with the same value on a slope chart 🙂
Thank you, worked perfectly.
User | Count |
---|---|
84 | |
77 | |
76 | |
43 | |
36 |
User | Count |
---|---|
109 | |
56 | |
52 | |
48 | |
43 |