Forum Discussion
apmulhearn
5 years agoHelper III
Same as Previous using Fiscal Week Numbers
Hello, I have a chart visual working well for me in my Dashboard, but I need to make a Card which summarizes some of that data. I am struggling here. Below is an image of the items I'm working wi...
amitchandak
5 years agoSuper User
apmulhearn , Try measures like
suxm(values(Table[Week end]),[Guests booked 2 yrs ago])
apmulhearn
5 years agoHelper III
Thank you so much for trying to help me, but I think I am misunderstanding something. The Week End Date comes from a Date Table, and the Guests Booked 2 Yrs Ago Come from an Invoice Table. It looks like SUMX is designed to work on 1 table. Am I getting something wrong here?
Thank you.