Forum Discussion

apmulhearn's avatar
apmulhearn
Icon for Helper III rankHelper III
5 years ago

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...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

apmulhearn , Try measures like

suxm(values(Table[Week end]),[Guests booked 2 yrs ago])

apmulhearn's avatar
apmulhearn
Icon for Helper III rankHelper III
5 years ago

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.