Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

If AND Statement

Can someone please assist with the following question, I need to be able to automatically set filter to latest fiscal week while keeping the year in mind. 

 

I did something similar for the date recently but I cannot seem to figure out how to apply same logic to two values. 

I was thinking an IF AND statement but I get stuck on writing it out, can someone help please? 

 

Today 2 =
IF
(Processed[Report Date] < (Processed[MAX DATE]),
FORMAT(Processed[Report Date],"yyyy-mm-dd"),
"Latest")

 

General Comment
Need Help
Tutorial Requests

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Came up with this, but it's not capturing the lastest week with consideration of the year...any ideas?

     

     

    • v-chenwuz-msft's avatar
      v-chenwuz-msft
      Community Support
      4 years ago

      Hi Anonymous ,

       

      Is that you created a column named FISCAL WEEK FILTER?

      Maybe you can change < to <= with the code you provided firstly.

       

      Today 2 =
      IF
      (Processed[Report Date] <= (Processed[MAX DATE]),
      FORMAT(Processed[Report Date],"yyyy-mm-dd"),
      "Latest")
       
      But i do not sure what is your Processed[MAX DATE] look like. Please share some your pbix file without sensitive data or sample data and expect result.
       

      Best Regards

      Community Support Team _ chenwu zhu

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.