Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
with the help of chat GPT i have create a calculated coloumn
You probably need to create a separate Date table and join with fact table. That would be more efficient and work all time rather than using DAX functions such as distinct to handle above slicer duplicate issue.
Please search ChatGPT on how to create date table for your model.
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.
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
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
87 | |
85 | |
73 | |
69 | |
65 |
User | Count |
---|---|
214 | |
124 | |
117 | |
82 | |
76 |