Forum Discussion

vinodDrinkPak's avatar
vinodDrinkPak
Helper II
3 years ago

Duplicate date values in my dropdown list

Hi,   with the help of chat GPT i have create a calculated coloumn  End of Week =     IF(ISBLANK([Shipment date]), BLANK(),         [Shipment date] + 7 - WEEKDAY([Shipment date])     ) But w...
Need Help
Show and Tell
foodd's avatar
foodd
Community Champion
3 years ago

Hello vinodDrinkPak and thank you for starting a conversation in the Power Query Forum.   It is unclear from your description what the problem with your data model is.   Would you please add your work-in-progress Power BI Desktop file, as well as any source files in Excel format.    To add the file, copy your file to Google Drive, One Drive, or Dropbox, add the anonymous sharing link to the original post, and add a reply to the thread that the post has been updated, and these have been added.  Please also with an image and description, of what the desired results should be.

vinodDrinkPak's avatar
vinodDrinkPak
Helper II
3 years ago

thanks, i manage to resolve the issue, End of week, i have calculated in M Query and then added that to slicer, it sorted out the issue

  • foodd's avatar
    foodd
    Community Champion
    3 years ago

    Great that you self-discovered a working solution!   Please mark this reply as a solution and provide Kudos so that others may find the solution easier.