topic Re: Varaible in measure in DAX Commands and Tips

Varaible in measure

Bakhtawar — Fri, 27 Dec 2019 12:39:48 GMT

Hi all

I have field i drag that field in sheet .. and there is some charts

first i want to save save varaible of date and then drag that varaible in sheet

then in formula i want to call that varaible against each date field whatever is in the tables.. for suppoise i have date field

OS_date and there is several dates in it

in qlik sense i have formula like this

sum({<AS_Date= {'$(VDate)'}, LOB = {'Mot'}>}OS_AMOUNT)

in DAX i created same formula like this

vMotor_ROS = CALCULATE(sum(OS_excel[OS_AMOUNT]),Premium_Excel[LOB]="Mot")

now i want to call that as_Date in formula .. how i do this ?

VDate is the empty varaible which i drag in sheet.. what every the date i write this should be effect on

As_Date

how i do this

sturlaws — Mon, 24 Feb 2020 14:05:17 GMT

I'm having trouble understanding your requirements. Could you provide some sample data, and create a mockup of the desired output?

Cheers,
Sturla

Pragati11 — Mon, 24 Feb 2020 14:20:11 GMT

I am able to understand your query clearly. Can you please provide some screenshots ans sample data for what you are trying to achieve here?

Thanks,

Pragati

Bakhtawar — Fri, 28 Feb 2020 13:00:45 GMT

please conisder abt sample data