Forum Discussion
markjhillier
8 years agoFrequent Visitor
Filter text value differences between date periods
Hi, I'd like to be able to filter a table based on differences in the text value of equivalent fields across two different date periods. For example, if I have a table containing item (text b...
Greg_Deckler
8 years agoCommunity Champion
I may have time to look at this in more detail, but it looks like you are going to need to use EARLIER in a measure. See my article on Mean Time Before Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/339586