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, I apologize in advance for this seemingly ignorant question. I am new to PowerBI and have been tasked with creating a visualization for a specific dataset. My issue is that I need to take a single column with dates (DEADLINE) and denote how many of these dates are 30 days away/60 days away and 90 days away.
I've tried other solutions posted on the boards but have had little success in accomplishing exactly what I am trying to do.
Thanks for your help in advance.
Solved! Go to Solution.
@ZGardner Easiest would be to do something like the following:
Days Away Column =
VAR __Days = (TODAY() - [DEADLINE]) * 1.
RETURN
SWITCH(TRUE(),
__Days <= 30,"30",
__Days <= 60,"60",
__Days <= 90,"90",
"90+"
)
could you please provide the sample data and expected output?
Proud to be a Super User!
@ZGardner Easiest would be to do something like the following:
Days Away Column =
VAR __Days = (TODAY() - [DEADLINE]) * 1.
RETURN
SWITCH(TRUE(),
__Days <= 30,"30",
__Days <= 60,"60",
__Days <= 90,"90",
"90+"
)
User | Count |
---|---|
86 | |
82 | |
68 | |
65 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |