Forum Discussion

lilykim's avatar
lilykim
New Member
2 years ago
Solved

How do I insert different date filter for one column only?

Week Ending Actual Goal Current Ratio % Previous Ratio % MM/DD/YYYY HH:MM A B (Table[Actual]/Table[Goal])*100 ((Table[Actual]/Table[Goal])*100)-7 ???   Hello,   I'm trying to dis...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    lilykim 

    pls try this

    Measure 2 = sumx(FILTER(all('Table'),'Table'[week ending]=max('Table'[week ending])-7),[Measure])

    pls see the attachment below

ryan_mayu's avatar
ryan_mayu
Super User
2 years ago

could you pls provide some sample data and the expected output?

lilykim's avatar
lilykim
New Member
2 years ago

Hi ryan_mayu

Here is sample data:


In a PBI table visualization, I want the last column [Previous Ratio %] to output the last week ending's [Current Ratio %].

 

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    2 years ago

    lilykim 

    pls try this

    Measure 2 = sumx(FILTER(all('Table'),'Table'[week ending]=max('Table'[week ending])-7),[Measure])

    pls see the attachment below