Forum Discussion
How to calculate dynamically Changing week
Hi, Need to find dynamically changing week i.e., need to display previous week(sales) vs current week(sales) against fiscal year.
Hi,
you can add a custom Column in powerquery to your calendar:
for example for previous week.
= Table.AddColumn(#"YourPreviousStep", "LastWeek", each if Date.IsInPreviousWeek([Date]) then "Yes" else "No")
and then you can you can build your measure with filter on those columns
/Adam