Forum Discussion
Quick Measure --> Filter by Relative Date?
Hi jdubs ,
Please try this measure:
Measure = VAR __today = TODAY() VAR __start_date = EDATE(__today, -12) VAR __result = CALCULATE([Count of Title],'Table'[createdon]>=__start_date && 'Table'[createdon]<__today+1) RETURN __resultBest Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi Dharmendar,
I tried this measure as you suggested but I get an error becuase there are duplicate dates in the date column (I actually tried this before making this post). I need to use a measure and not the visual filter becuase I am using multiple measures in a single table.
Thanks.
Hi jdubs ,
Please try this measure:
Measure =
VAR __today = TODAY()
VAR __start_date = EDATE(__today, -12)
VAR __result = CALCULATE([Count of Title],'Table'[createdon]>=__start_date && 'Table'[createdon]<__today+1)
RETURN
__result
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum