Forum Discussion
Show All Dates Weekly Dates With or Without Transactions
The goal is to track the weekly (or monthly) sales transactions. I have a fact table which has transactions along with a Date Dimension table. The relationship between the two tables are the transact...
Syndicate_Admin Hello. Would you be so kind as to provide advice on how I can create a table in which continuous dates can be highlighted on both a weekly and monthly cadance? I was able to find a workaround in which continuous consecutive daily dates can be displayed on a table by using the below listed measure. The goal is to do the same but on a weekly and monthly continuous consecutive cadance. Problem is the below measure works well for consecutive daily dates, not for weekly or monthly dates. Please let me know your thoughts.
IF(
[Product_Sales_Count] = BLANK(),
0,
[Product_Sales_Count]
)