Forum Discussion
SofiaK
2 years agoRegular Visitor
Two different time measures on one report page
Hi everyone, is there a way to have two different time columns on one page. I have two measures "work wins" and "open work" and created fiscal years for both, and these fiscal years are different for "won" work and "open" as won work based on “close date” and open work is based on “referral date”, so I have two fiscal years measures.
I need to create a report showing won info on one side and open on other for current fiscal year.
Maybe it’s possible to split the page in two to have slicers for different time measures?
Thanks for any help!
2 Replies
- Daniel29195
Community Champion
please refer to this :
https://www.sqlbi.com/articles/filtering-and-comparing-different-time-periods-with-power-bi/hope this helps.
- lbendlin
Super User
Read about USERELATIONSHIP