Forum Discussion
Offset function combined with field parameter
Hello, I would like to create a table that will show a change between 2 dates but requirement from the user is to be able to dynamically change time perspective view - so they would like to compa...
Here you can find powerbi file and excel with sample data.
https://www.dropbox.com/scl/fo/naasx1kq80ucpxw9o93oc/h?rlkey=mswsz1c7lgmwh1p98qh3t5fku&dl=0
Currently I have achieved what was wanted by creating additional dax table and using bookmarks.
However I just wanted to refactor this as I noticed that Field parameter option which I thought is more simple and more elegant.
Your Calendar table has gaps
You also didn't specify the four digit years so Power BI got confused.
I'd recommend you fix that table first.
