Data according to dates

[Bakhtawar]

Hi all

I have this kind of data in qlik sense

kindly check this video

https://streamable.com/83v6j

here in this only 1 variable is save as a date .. what ever the date we write according to date data will be effect ..

here CR formula is

sum({<Flag = {'RC'},LOB = {'M'},PAID_DATE =  {'<=$(VpeDate)'}>}P_AMOUNT)

and ROS  forumla is

sum({<LOB = {'Mt'},RC_AS_OF_DATE = {'$(VpeDate)'}>}RS_AMOUNT)

I created in power bi but i drag all 2 dates separately like this

check this power bi video

https://streamable.com/ky0d5

i create these formulas in power bi

vcr = CALCULATE(sum(Paid_excel[P_AMOUNT]),Paid_excel[Flag]="RC",Premium_Excel[LOB]="MT)

vROS = CALCULATE(sum(RecoveryOS_excel[RS_AMOUNT]),Premium_Excel[LOB]="MT")

now i dont understand how i called date field in these formulas as same as i called in qlik sense ?

any help please

kinldy check videos .. by copying and pasting link in new tab so you will better understand

[v-chuncz-msft]

@Bakhtawar 

You may drag [Date] from a disconnected calendar table to Slicer, use MIN, MAX, SELECTEDVALUE and VALUES to get the value, then apply virtual relationship in DAX measure.

• https://www.sqlbi.com/articles/variables-in-dax/
• https://www.sqlbi.com/articles/filter-arguments-in-calculate/

[Bakhtawar]

there is calendar table ... but this table is not linked with other tables... so there is no use of calendar tables