Forum Discussion
kilala
Resolver I
Resolver IHow to Filter Card based on filter in Measure
Hi all,
I have 2 measure [Balance] and [Balance LM]
I have visualise these 2 as TABLE and CARD.
In TABLE, i have following detail only:
In table, I have filtered the visua...
VijayP
Community Champion
Community Championkilala If you can show the result in both card and table to understand what exactly happening!
for MTD end and MTD date what measure you have used?
kilalaResolver I
Resolver I
I am trying to track the movement of invoice. e.g. how much payment has been made at this month to pay invoice as of last month.
if today is 31/12/2022:
MTD end date = 31/12/2022
mtd end date lm = 30/11/2022
I cannot use totalmtd because i need the amount as i'm not calculating from start of the month. I am calculating from start of business. For example, starting 1/1/2015 until 30/11/2022.
currently the value i'm getting in CARD is higher than TABLE.
E.g: CARD = 190,000
TABLE: 170,000