Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
How can I filter on today's date plus 14? I have a date column and I can join it to a calendar table date.
Hi @Maureen ,
This depends on your needs but without any details is difficult to give you a correct answer, you can try something similar to this:
Filter + 14 = CALCULATE ( SUM ( Table[Column] ); FILTER ( ALL ( Table[Date] ); Table[Date] <= TODAY () + 14 && Table[Date] >= TODAY () ) )
This will filter out the information from today until today plus 14.
Again this may not work because I don't have details of your needs.
Can you share some sample data and expected result?
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCheck out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!