Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I am trying to create a slicer or filter for a measure
My source data only has a "Billing Start date" and no "Billing Finish Date" we only have the term of contract i.e. 12, 24, 36, etc
I have created a measure to create "Billing Finish Date"
Solved! Go to Solution.
Hi @Anonymous
Based on your explanation, I create a sample file, you can take it for reference. See sample file attached below.
Besides, the easiest way is to create a column,
In Range Col = IF('All Bookings'[Billing Finish Date]<=TODAY(),"Expired","Booked")
Then, drag this column into the slicer:
Result:
Best Regards,
Community Support Team _ Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
Based on your explanation, I create a sample file, you can take it for reference. See sample file attached below.
Besides, the easiest way is to create a column,
In Range Col = IF('All Bookings'[Billing Finish Date]<=TODAY(),"Expired","Booked")
Then, drag this column into the slicer:
Result:
Best Regards,
Community Support Team _ Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Works like a dream thank you 🙂
@Anonymous , You have to create an independent table(NewTable) with these two values
Create measures using this
countx(filter(values(Bookings[Contract#]), [In Range] =max(NewTable[Value])),Bookings[Contract#])
Check my video on a similar topic
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k
As I can't get this to work do I have any other options in being able to filter my data?
When I try to create the new measure suggested with the new table name I get lots of errors
Any help will be appreciated
Thank you for such a quick answer
I have watched the video but as yet can’t get my head around what needs to be done, I believe I only need a small portion of your video and need two columns
Contract # and In Range
Is that correct?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
83 | |
71 | |
49 |
User | Count |
---|---|
143 | |
120 | |
110 | |
59 | |
57 |