Forum Discussion
What If Parameters two dates
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
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
2 Replies
- Pragati11Super User
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
- amitchandakSuper User
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