Forum Discussion
time filter creation
Hello!
I've checked links which you sent me but I still have questions.
Okay, I will create extra table with date which will connect with option creation time and will use 2 filters in the report instead of 1. But the problem is that I need to use 1 filter only for some columns and 2 filter - only for others columns in the same table and don't touch values in previous columns.
And also the question: if it's possible to use this dates in functions? Because I'm going to create calcuated table from this data after.
Thank you,
Ekaterina.
Hi Katerina_SL ,
Could you please share a sample data file and also share some specific expected calculations(visual) examples? sharing a pbix would be great.
1. I think I need to understand the specific use to understand how we can use different or same filter condition.
Also, meanwhile it would be nice to have a look at DAX functions which can help ignore filter context like ALL, ALLSELECTED, ALLEXCEPT. (use 1 or combination) with edit interactions on visual level to affect filters specifically from different filters.
2. Do you want to create a summary table in the data model? Then you can use SummarizeColumns, Summarize functions.
Bijen
Did I answer your question? Mark my post as a solution!
Appreciate your Kudos!! Happy to Help!