Forum Discussion

NiugeS's avatar
NiugeS
Icon for Helper V rankHelper V
6 years ago

If Filtered Date is Smaller then blank

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 f...
Need Help
NiugeS's avatar
NiugeS
Icon for Helper V rankHelper V
6 years ago

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:

 

AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
6 years ago

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