What If Parameters two dates

[Anonymous]

Hi,

Could somebody please help me with the DAX required for the two parameters columns below if I wanted them to both be dates?

I already have a date table set up.

Sample attached below

https://1drv.ms/u/s!AtcnGX-0tS5riSdCeUynmqBAUdLm?e=daza3U

Thanks

[amitchandak · Accepted solution]

@Anonymous , You can create two/one independent date table/s and use. 

example, check how one of the table is not joined

https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[Pragati11]

Hi @Anonymous ,

Your date parameter doesn't look right.

Have you tried referring to existing threads on this:

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Date-What-If-Parameter/m-p/989650

Check this if it helps.

Thanks,

Pragati