Forum Discussion

sunah132's avatar
sunah132
Helper I
5 years ago

Rank and Partition

I have a list of items with pricing as value by delivery date. Because the direct query data has multiple duplicated entries per items, the row subtotal shows 10X more than what it should be. If I cr...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi sunah132 

I took a look at the pbix file you provided, and the current rendering is as follows. What is the result you need, could you explain it? From the data you provide so far, I am not particularly clear about your needs.

Best Regards

Community Support Team _ Ailsa Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • sunah132's avatar
    sunah132
    Helper I
    5 years ago

    Hi Ailsa,

    There are multiple duplicated data per item and I had to bring the minimum cost of the table per day to sum up the total. There were daily pricing and misc. pricing on every Wednesday that I had to put together into the table with minimums on it. I tried tweaking Ryan's DAX to both charges added onto it but I was struggling getting them calculated. Thank you for look into this!