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
I have a table like this:
I need to get a table with just the last month information. So in this example, it would be dates just since 26/11/2022.
I have tried
Dummy tables:
https://drive.google.com/drive/folders/10nBzXYPfSuO87Sjl4_BkOdC2kVxQuDai?usp=share_link
Anyone could help me with this DAX expression? Thanks in advance!
Solved! Go to Solution.
hi @Laocsulak
try to write the table like this:
Date_Goal =
VAR _maxdate = EDATE( MAX(TableName[Date]), -1) +1
RETURN
CALCULATETABLE(
TableName,
TableName[Date]<=_maxdate
)
hi @Laocsulak
try to write the table like this:
Date_Goal =
VAR _maxdate = EDATE( MAX(TableName[Date]), -1) +1
RETURN
CALCULATETABLE(
TableName,
TableName[Date]<=_maxdate
)
Thanks! It solved the problem, changing the last inequality, using >= instead of <=.
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 |
---|---|
29 | |
14 | |
11 | |
10 | |
9 |