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 all,
Apologies if this is simple but i'm still learning.
I have a table that contains issues (support tickets). Sometimes these are resolved after the report period and I am trying to find a way that if the date is bigger then the Created Before slicer, it returns a blank value. There's a measure included to keep blank resolved dates and I assume that measure could be modified.
Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos.
I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
@az38 Thank you for the help. I tried to use the suggested measure but the table comes back blank. Am I doing somethign wrong?
@NiugeS Your sample pbix file doesn't match your description?
Try replacing BLANK() in the formula with a value like "A" and try putting the second argument in Selectedvalue, like:
SELECTEDVALUE('Issues'[Created], "B")
So final result will be;
What does the formula return now?
Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos.
I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query.
https://sites.google.com/site/allisonkennedycv
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
@AllisonKennedy Apologies .. i've udpated the sample pbix file.
I tried the formula provided but get all A in the table despite changing the dates in the slicer:
As you have alread mentioned, you need to use the right dates. Change the dates in the Created Before slicer and you will see the A change. If you're seeing 'A" that means that the condition in your IF statement is TRUE, if you see 'B' that means the condition in your IF statement is false and there is more than one value selected for that date.
Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos.
I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query.
https://sites.google.com/site/allisonkennedycv
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
@az38 Thanks for coming back to me. I'm not sure what i'm doing wrong but neither measure provide any results.
@az38 Apologies if I copied the wrong file link. I've updated the original message.
much better
1 set Active "Show tems with no data" for [Key] field in Visualizations pane
2 re-write your measure
Measure 2 =
var _Created = MIN('Issues'[Created])
RETURN
If(_Created > CALCULATE(MIN('Created Date'[Date])), BLANK(), SELECTEDVALUE('Issues'[Created]) )
but Im not sure I understand your condition logic correct
@az38 I think I should shut down the laptop for the night! I didn't explain my logic correctly ... i wanted resolved date as you probably guessed!
I will work on the suggestion you provided and see if I can make sense of it. Thank you.
@az38
Thank you for your help. I modified your previous suggestion before seeing the new one. The below seems to provide the desired results. Thank you for all your help. I'll try the other measure as well - thanks.
User | Count |
---|---|
92 | |
86 | |
67 | |
62 | |
58 |
User | Count |
---|---|
150 | |
113 | |
95 | |
80 | |
72 |