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 re...
General Comment
Need Help
Tutorial Requests
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
    Icon for Community Support rankCommunity 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.