Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello,
Can anyone help me to calculate last n days data but it should not consider the current date in calculation.
Thank you.
Solved! Go to Solution.
Hi,
I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
I hope the below can provide some ideas on how to create a solution for your datamodel.
The disconnected table shown in the below is created by using Numeric range new parameter feature.
Value total: =
SUM( Data[Value] )
Last N days value total: =
VAR _Ndays = [LastNdays Value]
VAR _window =
WINDOW (
- _Ndays,
REL,
-1,
REL,
ALL ( 'Calendar'[Date] ),
ORDERBY ( 'Calendar'[Date], ASC )
)
RETURN
IF ( COUNTROWS ( _window ) >= _Ndays, CALCULATE ( [Value total:], _window ) )
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
I hope the below can provide some ideas on how to create a solution for your datamodel.
The disconnected table shown in the below is created by using Numeric range new parameter feature.
Value total: =
SUM( Data[Value] )
Last N days value total: =
VAR _Ndays = [LastNdays Value]
VAR _window =
WINDOW (
- _Ndays,
REL,
-1,
REL,
ALL ( 'Calendar'[Date] ),
ORDERBY ( 'Calendar'[Date], ASC )
)
RETURN
IF ( COUNTROWS ( _window ) >= _Ndays, CALCULATE ( [Value total:], _window ) )
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Measure = calculate(TOPN(<N_Value>, <Table>, <OrderBy_Expression>, [<Order>[, <OrderBy_Expression>, [<Order>]]…]),table[date]<MAX(table[date]))
@msp_25 If this post helps, please consider accept as solution to help other members find it more quickly.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
107 | |
105 | |
89 | |
61 |
User | Count |
---|---|
168 | |
138 | |
134 | |
102 | |
86 |