Forum Discussion
Helper IIFiltering on period does not show expected result
Hello Dicko ,
What you need is to correct the granuality of the date table you have created. So, if you need to add a column for month, then you may use the following:
Result:
In addition, you might need to modify your relationships among the tables. You may find the file helpful:
Hope this helps.
Cheers!
Vivek
If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂 (Hit the thumbs up button!)
If it doesn't, then please share a sample data along with the expected results (preferably an excel file and not an image)
https://www.vivran.in/
Connect on LinkedIn
Community ChampionHello Dicko ,
What you need is to correct the granuality of the date table you have created. So, if you need to add a column for month, then you may use the following:
Result:
In addition, you might need to modify your relationships among the tables. You may find the file helpful:
Hope this helps.
Cheers!
Vivek
If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂 (Hit the thumbs up button!)
If it doesn't, then please share a sample data along with the expected results (preferably an excel file and not an image)
https://www.vivran.in/
Connect on LinkedIn
