Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm connecting Power BI Desktop to an Analysis Services cube. I want to limit the amount of data I import to make it more efficient. The data goes back some 25 years or so but I'm just interested in the last 3 years of data. I have written a DAX expression to apply some filters to the data. Please see below;
EVALUATE
CALCULATETABLE (
SUMMARIZECOLUMNS (
WorkingFeeEarner[Name],
"Input Local Value", [Local Rate Amount_Time]
),
WorkingFeeEarner[CurrTitleGroupName] = "Partner",
Matter[Type] = "Chargeable"
)
I want to further limit the data based on an invoice date. This data is stored as text in source. Would you happen to know how I can filter the data on date in a script like the above?
Many thanks
Chris
Solved! Go to Solution.
Hi @Cmoore ,
Maybe you can try:
CALCULATETABLE (
SUMMARIZECOLUMNS (
WorkingFeeEarner[Name],
"Input Local Value", [Local Rate Amount_Time]
),
WorkingFeeEarner[CurrTitleGroupName] = "Partner",
Matter[Type] = "Chargeable",
YEAR([Date]) <= YEAR(TODAY()) && YEAR([Date]) >= YEAR(TODAY())-3
)
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Cmoore ,
Maybe you can try:
CALCULATETABLE (
SUMMARIZECOLUMNS (
WorkingFeeEarner[Name],
"Input Local Value", [Local Rate Amount_Time]
),
WorkingFeeEarner[CurrTitleGroupName] = "Partner",
Matter[Type] = "Chargeable",
YEAR([Date]) <= YEAR(TODAY()) && YEAR([Date]) >= YEAR(TODAY())-3
)
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.