Search found 5 matches

by Hazdiggity
Wed Aug 22, 2018 2:25 pm
Forum: PowerPivot/DAX
Topic: Week Number for Fiscal Year
Replies: 3
Views: 197

Re: Week Number for Fiscal Year

Great that works pretty well!

The only thing is that my weeks run from Saturday to Friday i.e. the first day of each week is the Saturday.
The DAX is:

FY Week No = WEEKNUM('Calendar'[Date]+184,2)

Changing the 184 by 1 on either side means that the 1st of July isn't when the FY week resets.
by Hazdiggity
Wed Aug 22, 2018 11:51 am
Forum: PowerPivot/DAX
Topic: Week Number for Fiscal Year
Replies: 3
Views: 197

Week Number for Fiscal Year

Hi all, I have a separate calendar table that includes a column for "Week Number" calculated using the WEEKNUM formula. However, what would really be handy is a column for "Financial Week Number" that shows the week number (a week beginning on a Monday) starting from 1st July. Do...
by Hazdiggity
Mon Jul 02, 2018 12:45 pm
Forum: Power BI Desktop/Service
Topic: [Solved] Showing All Customers in a Table with Multiple Measures
Replies: 5
Views: 1845

Re: Showing All Customers in a Table with Multiple Measures

That does it! Thanks andredl - good trick!
by Hazdiggity
Mon Jul 02, 2018 9:21 am
Forum: Power BI Desktop/Service
Topic: [Solved] Showing All Customers in a Table with Multiple Measures
Replies: 5
Views: 1845

Re: Showing All Customers in a Table with Multiple Measures

The customer table is a separate lookup table
by Hazdiggity
Wed Jun 20, 2018 4:16 pm
Forum: Power BI Desktop/Service
Topic: [Solved] Showing All Customers in a Table with Multiple Measures
Replies: 5
Views: 1845

[Solved] Showing All Customers in a Table with Multiple Measures

Hi all, I have a Power BI Desktop report that contains: - Several slicers such as "Financial Year", "Product Type","Region" - A Table listing customers and a number of measures such as "Total Transactions", "Avg Purchase Amount", "User Rating&qu...

Go to advanced search