Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
amabrenda1986
Resolver I
Resolver I

Previous Month is Blank in Card Visual but not in Table

Hello 

 

Please can someone help me understand why I am having this issue and how to resolve it. If i use this formula CALCULATE([Properties],PREVIOUSMONTH('Calendar Table'[Date])) I get this as seen in the screen shot below:

 

amabrenda1986_0-1717021264507.png

 

When I try this formula CALCULATE([Properties],PREVIOUSMONTH(LASTDATE('Fact Table 1'[Property CreateDate]))), I get this as seen in the screen shot below

amabrenda1986_1-1717021330711.png

I want the system to calculate the total records for previous month. Your help is most appreciated. 

 

Even this formar 

Previous Month = CALCULATE([Properties],DATEADD('Calendar Table'[Date],-1,MONTH)), gives me the screen shot below, which is inacurate, because the 8,712 should not have been included in the previous month reported value
 
 
amabrenda1986_0-1717021780794.png

 

4 REPLIES 4
ryan_mayu
Super User
Super User

it looks like that your second try returns the correct value.

what's the expected output?

it returns blank is because you don't give the specific month for the card visual, so can't return the last month's value.

it works in the table because for each row there is a month slicer.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




well the expected output should not include the 8712. It should return the sum without 8,712

what about you sum all the amount and minus the latest month?

pls provide some sample data (not the table visual or the screenshot).





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Hello Ryan 

 

Please see sample data below

amabrenda1986_2-1717180705433.png

I used the queries for the start and end date:

 

Start date = #"Date.StartOfYear"(List.Min(Properties[Property CreateDate]))

 

End Date =#"Date.EndOfYear"(List.Max(Properties[Property CreateDate]))

 

Used the start and end date to create a table using this query:  = {Number.From(#"StartDate")..Number.From(#"EndDate")}

 

Followed these steps to create the calenda table

amabrenda1986_1-1717180541972.png

I would expect the previous month total to exclude Property ID = C30, the total of previous month will be 29.

 

Thanks in advance and for looking into this.

 

Some columns from my calendar table.

amabrenda1986_3-1717180825181.png

 

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors