Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hey Guys,
I have a card that currently pull data from excel sheet with a date and and amount. I currently manually change the day to show previous days amount. The problem I am having is I want this automated to show
for Monday it will show friday, saturday and sunday
Tuesday will show monday
Wednesday will show tuesday
Thursday will show wednesday
Friday will show thursday
Solved! Go to Solution.
You may use WEEKDAY Function in nested IF Function or SWITCH Function to add a measure.
You may use WEEKDAY Function in nested IF Function or SWITCH Function to add a measure.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |