Creating DAX rules to display received and sent dates based on one date column
Hello Folks, I really need your help to solve this problem that I have. I have the following sample data related to tickets treated during week number 15 of the month of April 2023, I would like to display the received and sent dates based on the Date of Action column (and only display the dates related to week number 15 of April, I have created a relationship btw between the date table and Date of Action column, but some outputs are still not correct), then calculate the time difference between the two (if the result is zero then it is understood that the ticket treatment was achieved in less than a day). I have implemented the following DAX calculations (thanks to user P_d2023 ) to get the results I have shown in the Power canvas belo PERSON_TIMELINE = RANKX(FILTER(WEEKLY_IDs, WEEKLY_IDs[Ticket_Nb] = EARLIER(WEEKLY_IDs[Ticket_Nb]) && WEEKLY_IDs[Sender_Name] = EARLIER(WEEKLY_IDs[Sender_Name])), WEEKLY_IDs[Date_of_Action], , ASC, Dense) TICKET_TIMELINE = RANKX(FILTER(WEEKLY_IDs, WEEKLY_IDs[Ticket_Nb] = EARLIER(WEEKLY_IDs[Ticket_Nb])),WEEKLY_IDs[Date_of_Action], , ASC, Dense) From the above calculations, I created the three columns shown in the Power BI report below: RECEIVED_DATE = CALCULATE(MIN(WEEKLY_IDs[Date_of_Action]), ALLEXCEPT(WEEKLY_IDs, WEEKLY_IDs[Ticket_Nb]), WEEKLY_IDs[TICKET_TIMELINE]=WEEKLY_IDs[PERSON_TIMELINE]) REPLY_DATE = IF( ISBLANK(CALCULATE(MIN(WEEKLY_IDs[Date_of_Action]), ALLEXCEPT(WEEKLY_IDs, WEEKLY_IDs[Ticket_Nb]), WEEKLY_IDs[TICKET_TIMELINE] > WEEKLY_IDs[PERSON_TIMELINE])), WEEKLY_IDs[RECEIVED_DATE], CALCULATE(MIN(WEEKLY_IDs[Date_of_Action]), ALLEXCEPT(WEEKLY_IDs, WEEKLY_IDs[Ticket_Nb]), WEEKLY_IDs[TICKET_TIMELINE] > WEEKLY_IDs[PERSON_TIMELINE]) ) Treatment Duration = if(INT([REPLY_DATE])-INT([RECEIVED_DATE]) <= 0,0, INT([REPLY_DATE]) - INT([RECEIVED_DATE]))VERY ODD - A report created with a slicer in RS 2018 - has correct year, not when published
Hello Fellow PBIers, I have a report that was created and published in RS 2018. It has a slicer on date - Month Year. When created and subsequently downloaded from the portal to my laptop - the slicer dates are correct: April 2021 May 2021 etc The data is also correct. When published to the portal the same slicer shows April 2022 May 2022 etc The data is still correct and shoing for Apr 2021, May 2021 etc This is driving me nuts but I can't help but be amused at its oddity. Has anyone ever seen this before and know a solution? Thanks ROO josef78 - Tagging you as you were able to help last time and have a great deal of experience!!!
