Question

Please how do I perfectly create a relationship in power pivot between a date table (daily) and a Month table (Month)

score 19 · Answer 1 · 2024-03-13T01:07:03.840000

19

Views

Please how do I perfectly create a relationship in power pivot between a date table (daily) and a Month table (Month)

Published on 13 March 2024 at 01:07

score 19 · Answer 2 · 2024-03-11T11:15:00.777000

19

Views

Is there a DAX function that takes Year, Month, and Week Number as inputs and then return a Date corresponding to the inputs?

Published on 11 March 2024 at 11:15

score 27 · Answer 3 · 2024-03-11T10:39:36.143000

27

Views

Define MDX Update Allocation Method - Excel What-If Calculate Change

Published on 11 March 2024 at 10:39

score 32 · Answer 4 · 2024-03-09T15:52:47.797000

32

Views

DAX IF function syntax error- creating a conditional column

Published on 09 March 2024 at 15:52

score 32 · Answer 5 · 2024-02-28T07:41:52.660000

32

Views

DAX - Blank values produced in my pivot when combining CALCULATE and PREVIOUS MONTH

Published on 28 February 2024 at 07:41

score 62 · Answer 6 · 2024-02-27T04:16:47.020000

62

Views

How to write dax formula like lag function without circular dependency in Excel Power Pivot

Published on 27 February 2024 at 04:16

score 37 · Answer 7 · 2024-02-23T19:55:11.010000

37

Views

PowerPivot Data Model Causing Cartesian Product

Published on 23 February 2024 at 19:55

score 60 · Answer 8 · 2024-02-20T19:06:04.897000

60

Views

Is Excel Power Pivot “double compression” a recognised effect?

Published on 20 February 2024 at 19:06

score 38 · Answer 9 · 2024-02-19T17:28:09.650000

38

Views

PivotTable filter not running and failing to apply

Published on 19 February 2024 at 17:28

score 38 · Answer 10 · 2024-02-16T14:47:58.193000

38

Views

How to get 'Sum' working in Calculated field based on another calculation?

Published on 16 February 2024 at 14:47

score 75 · Answer 11 · 2024-02-16T11:23:59.310000

75

Views

Calculating Employee Headcount per month in PowerPivot

Published on 16 February 2024 at 11:23

score 35 · Answer 12 · 2024-02-16T10:36:59.173000

35

Views

Using a single slicer to dynamically filter multiple pivottables from excel data model

Published on 16 February 2024 at 10:36

score 69 · Answer 13 · 2024-02-10T00:49:52.023000

69

Views

How to create a DAX formula to create another column based on the value in another column

Published on 10 February 2024 at 00:49

score 28 · Answer 14 · 2024-02-07T02:16:25.067000

28

Views

How do I create a Pivot Table chart Slicer that drills down from 'Cohort' to 'Class 1' and 'Class 2'?

Published on 07 February 2024 at 02:16

score 38 · Answer 15 · 2024-02-06T06:37:48.063000

38

Views

Excel DAX: Dynamically calculate the countof rows where each row's value is compared to the min value

Published on 06 February 2024 at 06:37

score 111 · Answer 16 · 2024-01-29T01:15:39.707000

111

Views

Retrieving data from DataModel (Power Pivot) within VBA

Published on 29 January 2024 at 01:15

score 37 · Answer 17 · 2024-01-26T23:22:47.657000

37

Views

DAX - using if formula in filter

Published on 26 January 2024 at 23:22

score 25 · Answer 18 · 2024-01-23T08:11:44.247000

25

Views

I have added 4 tables in power query of excel and done transformation but while moving to data model i am getting 2 table only?

Published on 23 January 2024 at 08:11

score 65 · Answer 19 · 2024-01-22T11:50:18.227000

65

Views

How Can I make measure SUM my amount according to level and parent category? using power bi

Published on 22 January 2024 at 11:50

score 23 · Answer 20 · 2024-01-19T10:58:07.567000

23

Views

PowerPivot - Average of column for a variable repeating for each row based on time period

Published on 19 January 2024 at 10:58

List Question

Please how do I perfectly create a relationship in power pivot between a date table (daily) and a Month table (Month)

Is there a DAX function that takes Year, Month, and Week Number as inputs and then return a Date corresponding to the inputs?

Define MDX Update Allocation Method - Excel What-If Calculate Change

DAX IF function syntax error- creating a conditional column

DAX - Blank values produced in my pivot when combining CALCULATE and PREVIOUS MONTH

How to write dax formula like lag function without circular dependency in Excel Power Pivot

PowerPivot Data Model Causing Cartesian Product

Is Excel Power Pivot “double compression” a recognised effect?

PivotTable filter not running and failing to apply

How to get 'Sum' working in Calculated field based on another calculation?

Calculating Employee Headcount per month in PowerPivot

Using a single slicer to dynamically filter multiple pivottables from excel data model

How to create a DAX formula to create another column based on the value in another column

How do I create a Pivot Table chart Slicer that drills down from 'Cohort' to 'Class 1' and 'Class 2'?

Excel DAX: Dynamically calculate the countof rows where each row's value is compared to the min value

Retrieving data from DataModel (Power Pivot) within VBA

DAX - using if formula in filter

I have added 4 tables in power query of excel and done transformation but while moving to data model i am getting 2 table only?

How Can I make measure SUM my amount according to level and parent category? using power bi

PowerPivot - Average of column for a variable repeating for each row based on time period

Trending Questions

Popular # Hahtags

Popular Questions