Styjun

Performance for simple code that converts a RGB tuple to hex string

How do I deal with too many NPCs in my campaign?

Can Northern Ireland's border issue be solved by repartition?

Can the U.S. president make military decisions without consulting anyone?

What is the lowest voltage that a microcontroller can successfully read on the analog pin?

Is it impolite to ask for halal food when traveling to and in Thailand?

An Algorithm Which Schedules Your Life

Is there any reason nowadays to use a neon indicator lamp instead of an LED?

Why does NASA publish all the results/data it gets?

Examples of "unsuccessful" theories with afterlives

How to ask a man to not take up more than one seat on public transport while avoiding conflict?

Where does an unaligned creature's soul go after death?

How use custom order in folder on Windows 7 and 10

How can an attacker use robots.txt?

Late 1970's and 6502 chip facilities for operating systems

Resolving moral conflict

Is it possible to constructively prove that every quaternion has a square root?

What is this utensil for?

Is this a Sherman, and if so what model?

Who created the Lightning Web Component?

Transforming 2D points on to a regular grid or lattice

How to manage expenditure when billing cycles and paycheck cycles are not aligned?

How to deal with my team leader who keeps calling me about project updates even though I am on leave for personal reasons?

Hilbert's hotel, why can't I repeat it infinitely many times?

How can I calculate a fiscal YTD measure with having a date table that's based on YYYYMM?

Difference in months between two datesHow to calculate a fiscal day of year in Excel?Custom Calendar in Power BI (DAX) - Calculated column for Fiscal QuarterCalculating difference of the values in same column of table by a date column of other tableHow to design QTD, MTD and YTD for the below listed table structure?How to calculate the Previous YTD for below mentioned table structure?How to build a Dax to view data of all the months till data w.r.t all the years?Measure in DAX to calculate YTD for chosen month only for Power BICalculated column: week number of a fiscal yearNeed a different YTD formula in DAX for Power BI - standard YTD doesn't work

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I have revenue for two years (2017 and 2018). It is store based and based on months in the format YYYYMM. My fiscal year is from April to March in this example. My question is how can I make a fiscal YTD measure for the current year (2018) and my previous year (2017).

When I use my date filters (I separated my revenue column) it only shows the data and YTD data for 2018 and the month 2017. Not the YTD for 2017.

I have tried the normal YTD function of Power BI (which didn't work in the way I wanted). Next I've tried below;

Revenue YTD 2018 = 
VALUE ( 
 CALCULATE ( 
 SUM ( [Revenue 2018] ); 
 DATESYTD ( Date[date]; "01/04" )
 )
)

In that instance I tried to label my data to a specific date. I get the expected values for 2018 but not for 2017. I also tried the code below but that gives no values;

Revenue YTD =
CALCULATE (
 SUM ( [Revenue] );
 VAR FirstFiscalMonth = 4
 VAR LastDay =
 MAX ( 'Date'[Date] )
 VAR LastMonth =
 MONTH ( LastDay )
 VAR LastYear =
 YEAR ( LastDay )
 - IF ( LastMonth < FirstFiscalMonth; 1 )
 VAR FilterYtd =
 DATESBETWEEN ( 'Date'[Date]; DATE ( LastYear; FirstFiscalMonth; 1 ); LastDay )
 RETURN
 FilterYtd
)

I expect to give the revenue to be calculated as I would in Excel. In this case I don't get the (full) values. I would expect that it would calculate the YTD values for both 2017 and 2018 and not one of both.

date powerbi dax

share|improve this question

edited Mar 28 at 16:02

Olly

5,70911 gold badge1212 silver badges3030 bronze badges

asked Mar 28 at 15:50

RobbertRobbert

1

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can you make an example of some of your data to grasp what yoo look for.
  
  – Aldert
  Mar 28 at 19:59
  

  
  
  
  

add a comment
 | 

0

I have revenue for two years (2017 and 2018). It is store based and based on months in the format YYYYMM. My fiscal year is from April to March in this example. My question is how can I make a fiscal YTD measure for the current year (2018) and my previous year (2017).

When I use my date filters (I separated my revenue column) it only shows the data and YTD data for 2018 and the month 2017. Not the YTD for 2017.

I have tried the normal YTD function of Power BI (which didn't work in the way I wanted). Next I've tried below;

Revenue YTD 2018 = 
VALUE ( 
 CALCULATE ( 
 SUM ( [Revenue 2018] ); 
 DATESYTD ( Date[date]; "01/04" )
 )
)

In that instance I tried to label my data to a specific date. I get the expected values for 2018 but not for 2017. I also tried the code below but that gives no values;

Revenue YTD =
CALCULATE (
 SUM ( [Revenue] );
 VAR FirstFiscalMonth = 4
 VAR LastDay =
 MAX ( 'Date'[Date] )
 VAR LastMonth =
 MONTH ( LastDay )
 VAR LastYear =
 YEAR ( LastDay )
 - IF ( LastMonth < FirstFiscalMonth; 1 )
 VAR FilterYtd =
 DATESBETWEEN ( 'Date'[Date]; DATE ( LastYear; FirstFiscalMonth; 1 ); LastDay )
 RETURN
 FilterYtd
)

I expect to give the revenue to be calculated as I would in Excel. In this case I don't get the (full) values. I would expect that it would calculate the YTD values for both 2017 and 2018 and not one of both.

date powerbi dax

share|improve this question

edited Mar 28 at 16:02

Olly

5,70911 gold badge1212 silver badges3030 bronze badges

asked Mar 28 at 15:50

RobbertRobbert

1

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can you make an example of some of your data to grasp what yoo look for.
  
  – Aldert
  Mar 28 at 19:59
  

  
  
  
  

add a comment
 | 

I have revenue for two years (2017 and 2018). It is store based and based on months in the format YYYYMM. My fiscal year is from April to March in this example. My question is how can I make a fiscal YTD measure for the current year (2018) and my previous year (2017).

When I use my date filters (I separated my revenue column) it only shows the data and YTD data for 2018 and the month 2017. Not the YTD for 2017.

I have tried the normal YTD function of Power BI (which didn't work in the way I wanted). Next I've tried below;

Revenue YTD 2018 = 
VALUE ( 
 CALCULATE ( 
 SUM ( [Revenue 2018] ); 
 DATESYTD ( Date[date]; "01/04" )
 )
)

In that instance I tried to label my data to a specific date. I get the expected values for 2018 but not for 2017. I also tried the code below but that gives no values;

Revenue YTD =
CALCULATE (
 SUM ( [Revenue] );
 VAR FirstFiscalMonth = 4
 VAR LastDay =
 MAX ( 'Date'[Date] )
 VAR LastMonth =
 MONTH ( LastDay )
 VAR LastYear =
 YEAR ( LastDay )
 - IF ( LastMonth < FirstFiscalMonth; 1 )
 VAR FilterYtd =
 DATESBETWEEN ( 'Date'[Date]; DATE ( LastYear; FirstFiscalMonth; 1 ); LastDay )
 RETURN
 FilterYtd
)

I expect to give the revenue to be calculated as I would in Excel. In this case I don't get the (full) values. I would expect that it would calculate the YTD values for both 2017 and 2018 and not one of both.

date powerbi dax

share|improve this question

edited Mar 28 at 16:02

Olly

5,70911 gold badge1212 silver badges3030 bronze badges

asked Mar 28 at 15:50

RobbertRobbert

1

Revenue YTD 2018 = 
VALUE ( 
 CALCULATE ( 
 SUM ( [Revenue 2018] ); 
 DATESYTD ( Date[date]; "01/04" )
 )
)

Revenue YTD =
CALCULATE (
 SUM ( [Revenue] );
 VAR FirstFiscalMonth = 4
 VAR LastDay =
 MAX ( 'Date'[Date] )
 VAR LastMonth =
 MONTH ( LastDay )
 VAR LastYear =
 YEAR ( LastDay )
 - IF ( LastMonth < FirstFiscalMonth; 1 )
 VAR FilterYtd =
 DATESBETWEEN ( 'Date'[Date]; DATE ( LastYear; FirstFiscalMonth; 1 ); LastDay )
 RETURN
 FilterYtd
)

share|improve this question

edited Mar 28 at 16:02

Olly

5,70911 gold badge1212 silver badges3030 bronze badges

asked Mar 28 at 15:50

RobbertRobbert

1

share|improve this question

edited Mar 28 at 16:02

Olly

5,70911 gold badge1212 silver badges3030 bronze badges

asked Mar 28 at 15:50

RobbertRobbert

1

edited Mar 28 at 16:02

Olly

5,70911 gold badge1212 silver badges3030 bronze badges

edited Mar 28 at 16:02

Olly

5,70911 gold badge1212 silver badges3030 bronze badges

asked Mar 28 at 15:50

RobbertRobbert

1

asked Mar 28 at 15:50

RobbertRobbert

1