The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.