Select a result to preview

FISCAL MONTH NUMBER CALC

#Power_bi #Data

BI and PQ DATA TIPS AND TRICKS

POWER PIVOT DAX

FISCAL_MONTH_NUMBER
=if('Calendar'[Month Number]<7,'Calendar'[Month Number]+6,MOD('Calendar'[Month Number],7)+1)