Forum Discussion

Faye1901's avatar
Faye1901
Helper I
7 years ago

Secondary Filter IF statement

Hi All

 

I have a simple IF statement that works to display an image URL when conditions are met, but I'd like it to evaluate only in the context of THIS calendar month. At the moment it either rolls up the result for all months in my table or I can get it to display direcrly in a table with each month represented.

It will let me have a second filter but it's not working.

Any ideas?

Up or Down Red = IF([Difference red]=0, PWAURL & "/_layouts/15/inc/PWA/images/cf_50p.png", PWAURL & "/_layouts/15/inc/PWA/images/cf_42p.png")

*Difference Red is just count of current - count of previous month data

Thanks
Faye
Need Help
Tips and Tricks

2 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    Hi Faye1901,

     

    Here I made a test by creating a caluclate column.

     

    Column = IF(Table2[Difference red]=0,MAX(Table1[Column1]),MIN(Table1[Column1]))

    Then change the column to Web URL.

     

     

    Regards,

    Frank

    • Faye1901's avatar
      Faye1901
      Helper I
      7 years ago

      Thanks for this. I've realised that a calculated column is the answer for sure - so I'm back to the drawing board. 

      I've now: 
      1. Created a summary table (so I don't need all those measures) using: 

      Snapshot Summary =
      SUMMARIZE (
      ProjectSnapshots,
      ProjectSnapshots[OverallStatus],
      ProjectSnapshots[Created]
      ,"Count of Statuses", COUNT( ProjectSnapshots[OverallStatus] ))

      2. Trying to create a measure for the previous month without success, at the moment I have: 
      Previous Count = sumx(filter(all('Snapshot Summary'), [Created].[MonthNo]=EARLIER('Snapshot Summary'[Created].[MonthNo])-1), 'Snapshot Summary'[Count of Statuses])
       But I'm getting the incorrect result. See below. 


      3. Once I've got that going then I can write the IF statement and it should work :) 

      Any thoughts! Feels like I'm close to a solution but not quite!