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.
Hello hello, I wanted to ask for a little guidance to be able to make a filter that can give me the corresponding year but mainly that the month starts from the 20th of the previous month to the 21st of the month consulted, giving as an example that if today 21-05-2024 I require the information of January it gives me the data from 21-12-2023 to 20-01-2024, Thank you very much in advance
This one worked for me;
To not overcomplicate yourself, I would recommend just use the date field in a slicer, set it up as a Between type and input your dates:
Proud to be a Super User!
I mean, I currently have it like this, the question is if there was something more friendly, like just selecting the month and having it perform the automatic conditioning
You wouldn't be able to use them as filters but you could create a pretty customized measure with time-intelligence and parameters. Something like:
DynamicMeasure = CALCULATE([WhateverExpressionYouWantToShow], DATESINPERIOD('DateTable'[Date], TODAY(),[ParameterField], MONTH))
Proud to be a Super User!
If it really works for me, I ended up doing the following:
I made a start date
Thank you very much for your help
User | Count |
---|---|
86 | |
82 | |
68 | |
65 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |