How to calculate day level sales by comparing two Date Field?

[NidhiBhusari]

I need to implement this logic in PowerBI which calculates values at the Day level i.e when the Date selected from the slicer is equal to Policy Approval Date then only it should give me the output. Can anybody please help me with the DAX in Power BI?

Tableau:- Two parameters have been created for Start & End Date compared with Policy Approval Date.
PowerBI:- Created Calendar Table whose Date field is used in the slicer and is compared with Policy Approval Date.

[NidhiBhusari]

There are two parameters created in Tableau for Start and End Date. which are compared with Policy Approval Date column. Please help me with the DAX for below logic.

[lbendlin]

AND in DAX speak is &&

Instead of case ... when ... you can use SWITCH()

if you like more help please post a text version of the code.

[Anonymous]

Hi @NidhiBhusari ,

I'm not good at Tableau, you may try this formula.

measure =
var match_date = SELECTEDVALUE([Policy Approval]) = Selectedvalue([slicer])
return
switch(true(),

match_date&&[select measure] = "premiun in crores", [premiun]/10000000,

match_date&&[select measure] = "policies",[policycount],

...etc

)

If it doesn't work, please share some sample data and expected result.

Best Regards,

Jay