Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Dynamic date based revenue calculation

Hi,   I have the following case:   I am building a report based on an Excel file hosted on a SharePoint Online environment. The file basically contains CRM opportunity lines with creation date, m...
DAX
Direct Query
parameters
Slicer
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous , You can create slicer on column from date  table

 

select today

Is Today = if('Date'[Date]=TODAY(),"Today",[Date]&"")

 

select max date

 

Is Today = if('Date'[Date]=Max(sales[sales date]) ,"Max Date",[Date]&"")

 

You can use time intelligence for MTD, QTD ytd etd

 

Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s

 

Power BI Offset Compare Categories, Time Intelligence MOM, QOQ, and YOY: https://youtu.be/5YMlkDNGr0U

 

Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc