Forum Discussion

CKC's avatar
CKC
Frequent Visitor
2 years ago
Solved

How do i create a monthly sales report?

Hi, I currently have a report that groups up sales by the month, I have it updating daily as I want the most up to date sales in the current month. Is there a way for power bi to check if the dates v...
Need Help
  • CKC's avatar
    CKC
    2 years ago

    parry2k 

    I ended up changing a different part of my process that fixed the issue. Thanks for your help

     

parry2k's avatar
parry2k
Icon for Super User rankSuper User
2 years ago

CKC not sure what you are referring too. Are you seeing multiple rows in the visual or in Power Query or in a Table view? Please be specific.

CKC's avatar
CKC
Frequent Visitor
2 years ago

parry2k 

 

In my Screenshot, the bottom two rows are from the same date, When my report updates a new row is created that includes the date 2024-04. My report updates daily so after 1 week I have multiple rows with the same date value. Is there a way I can replace the older rows with the newers rows that have the same date?