Forum Discussion
pbiforum123
Post Patron
Post PatronHelp 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...
pbiforum123Post Patron
Post PatronThanks but you have passed wrong date here hence it was working...
Sample[Date] >= date(2019,9,1)
&& Sample[Date] <= date(2019,9,30), "SampleOlderThanThisMonth",
It should have date(1900,1,1)...
pbiforum123Post Patron
Post PatronAs a quick fix I renamed the "Subtotal" to "Total Sales" 🙂
Only concern is I am not able to bring it to the top though I select Top in the subtotal settings.