I have this date format and I would like to only see the past 30 days for Labor billed in my report.
Does anyone know how I can create a measure for past 30 days?
You could use below measure :
Appreciate your Kudos and please mark it as a solution if it helps you
In the Query Editor, seperate the Time from the End Date column. Create a Calendar Table and a relationship (Many to One and SIngle) from the End Date column to the Calendar Table. Wrie these measure
LB = sum(Data[Labor billed])
LB in last 30 days = calculate([LB],datesbetween(calendar[Date],today()-29,today()))
Drag the LB in last 30 days measure to a card visual.
Hope this helps.
Please follow the instructions i have mentioned in my previous message.
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.