Forum Discussion

alminho's avatar
alminho
New Member
10 months ago
Solved

Help with setting up a model - beginner

Hi everyone,    I have a somewhat cumbersome issue - and I know this might be frustrating to many to read - but I'm genuinely stuck here. PS long post.   Background: Want to see active members on...
Need Help
  • alminho's avatar
    alminho
    10 months ago

    Hi - and thank you! 

    The issue has been solved. Unfortunately I had to clean up my dates a lot (debited until lasting until year 2900 for example). 

v-kpoloju-msft's avatar
v-kpoloju-msft
Community Support
10 months ago

Hi alminho,

Thank you for reaching out to the Microsoft fabric community forum. Also, thanks to kushanNa, Ilgar_Zarbali, Kishore_KVN, for those inputs on this thread. I reproduced the scenario again, and it worked on my end. I used it as sample data and successfully implemented it.

outcome:

 


I am also including .pbix file for your better understanding, please have a look into it.

Hope this clears it up. Let us know if you have any doubts regarding this. We will be happy to help.

Thank you for using the Microsoft Fabric Community Forum.

alminho's avatar
alminho
New Member
10 months ago

Hi - and thank you! 

The issue has been solved. Unfortunately I had to clean up my dates a lot (debited until lasting until year 2900 for example). 

  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    Community Support
    10 months ago

    Hi alminho,

    Thank you for confirming that the issue has been resolved. Cleaning up the date values especially those extending far into the future was a great step, as such data can often impact visuals and calculations unexpectedly.

    We appreciate you sharing your resolution, as it may assist other community members facing similar issues.

    Thank you again for using the Microsoft Fabric Community Forum.