Forum Discussion
Data according to dates
Hi all
I have this kind of data in qlik sense
kindly check this video
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
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
2 Replies
- v-chuncz-msft
Community Support
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.
- Bakhtawar
Post Patron
there is calendar table ... but this table is not linked with other tables... so there is no use of calendar tables