Forum Discussion
ValueCreate
Helper I
6 years agoCreating Future Quarter Dates
Hi! First time posting on here, will probably be posting more in the future as I am new to Power Bi. My question is regarding forecasting and creating future quarter end dates. The project I am w...
- 6 years ago
Hi, ValueCreate
You may create one more measure as below.
Result = IF( ISBLANK([futurequarterdate2]), [futurequarterdate1], IF( ISBLANK([futurequarterdate3]), [futurequarterdate1]&","&[futurequarterdate2], IF( ISBLANK([futurequarterdate4]), [futurequarterdate1]&","&[futurequarterdate2]&","&[futurequarterdate3], [futurequarterdate1]&","&[futurequarterdate2]&","&[futurequarterdate3]&","&[futurequarterdate4] ) ) )Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- 6 years ago
Hi, ValueCreate
If you take the answer of someone, please mark it as the solution to help the other members who have same problems find it more quickly. If not, let me know and I'll try to help you further. Thanks.
Best Regards
Allan
v-alq-msft
Community Support
6 years agoHi, ValueCreate
If you take the answer of someone, please mark it as the solution to help the other members who have same problems find it more quickly. If not, let me know and I'll try to help you further. Thanks.
Best Regards
Allan