Forum Discussion
Help required in Switch statement
Since the first statement for "Total Sales" consists of the dates rest of the statement is not executed. If I remove the first statement which is "Total Sales" rest of the statement is executed. Wha...
Hi pbiforum123 ,
Sales[Date] >= date(1900,1,1)
&& Sales[Date] <= date(2900,12,31), "Total Sales",Sales[Date] >= date(2019,11,30)
&& Sales[Date] <= date(2900,12,31), "SalesFuture"The two expressions‘ date ranges have duplicate parts. Why do you write like so?
Best Regards,
Icey
As date days one gives the total sales and other gives the future sales...