I am trying to create a new column where only unique order ID are present duplicates are blank I want this calculation done based on sales only the max sales order ID should be considered, Is it possible to do so ?
Is there a way to find duplicates in measures? like EARLIER()?, thing is, i have a date slicer and i want to find the duplicates within the [slicer date] and [slicer date] - 30 days
Hi sir, i was done merging two tables, out of 1000 rows i got 500 rows are common when I do innerjoin but while loading power bi and doing refresh 1000 rows are loaded then it's taking more time to refresh so how to resolve this i want to refresh only 500 rows
It's not necessary to sort the column. I think he did it just to show quickly the repeated order ids. Just tried in on a different dataset and works fine without sorting
Finished watching
Thank you so much SiR
Thanks for the tutorial spreadsheet, stay blessed.
Its helpful for me, Thankyou
I am trying to create a new column where only unique order ID are present duplicates are blank I want this calculation done based on sales only the max sales order ID should be considered, Is it possible to do so ?
In a table or a matrix, I have count of 3 as qty and under 3 below row, how do I get 3 corresponding product I'd in power bi.
Where do I find the link to your excel sheet ? Thanks
Is there a way to find duplicates in measures? like EARLIER()?, thing is, i have a date slicer and i want to find the duplicates within the [slicer date] and [slicer date] - 30 days
Hi sir, i was done merging two tables, out of 1000 rows i got 500 rows are common when I do innerjoin but while loading power bi and doing refresh 1000 rows are loaded then it's taking more time to refresh so how to resolve this i want to refresh only 500 rows
Probably you need incremental load I believe in this scenario after inner join.
You r Rock Sir
Could you explain why it is necessary to sort?
It's not necessary to sort the column. I think he did it just to show quickly the repeated order ids. Just tried in on a different dataset and works fine without sorting
Awesome, thanks!